Assuming that what you see below is the only content of the active worksheet in the active workbook, which VBA expression will get the number of the last line (many good answers)

Question

Answer

Cells(Rows.Count,1).End(XlUp).Row

Answer

ActiveSheet.Rows.Count

Answer

Cells(1,1).End(Xldown).Row

Answer

Cells(1,1).CurrentRegion.Rows.Count

Crowdly

Assuming that what you see below is the only content of the active worksheet in ...

Want instant access to all verified answers on k2.skema.edu?