The last used cell in column A

[Jaymond Flurrie]

How do I find the last used cell in column A? I know I can use "Range("A1048576").End(xlUp)" but that's not very smart - what if the the code is run on Excel 2003? I could use "if application.version < 12.0 then" and so on, but is there really not any easier way?

One thing to note is that the column A can have multiple empty cells - I just need the address of the one that is the last that has anything on it.

 

[jeffreybrown]

Try

LR = Range("A" & Rows.Count).End(xlUp).row

 

[Ragnar1211]

Or similarly:

LR = cells(rows.count,1).end(xlup).row

 

[Smitty]

You can use:

MsgBox Cells(Rows.Count, "A").End(xlUp).Address

That will work regardless of version.

 

[Jaymond Flurrie]

Thank you this solved my problem. Just like I thought, the solution was very simple.