new vbl user, How to code list with dif # rows

[WGGMKG]

EASY QUESTION--I would like to know what the code is to incorporate all rows in a spreadsheet for a macro, but to be able to use the macro on similar spreadsheets with varing number of rows.

 

[Andrew Poulsom]

Like this?

With Worksheets("Sheet1")
   MsgBox .Range("A1:A" & .Cells(.Rows.Count, 1).End(xlUp).Row).Address
End With

 

[WGGMKG]

not quite.

I recieved a box that showed the range that was now included in teh spreadsheet, but when the macro finished running, it only pulled the info from the original ranges.