find last row with data and copy all rows from bottom up?

[Sayre]

Can't seem to find a previous post that addresses this exactly.

I need some VBA code that will identify the last row with data in it on any given sheet and select all rows between it and the 1st row.

Any ideas?

 

[MichaelRo]

Assuming Column A is the most populated column try:

Selects the whole row of the specified range:

Range(Range("A65536").End(xlUp).Row & ":" & Range("A1")).Select

Selects the range based on Column A being the most populated and Row 1 containing the most data:

Range(Cells(1, 1), Cells(Range("A65536").End(xlUp).Row, Range("IV1").End(xlToLeft).Column)).Select