Specify last row

[Noz2k]

I want to specify the last row in a table, but can only remember how to do it if the table starts in "A1".

lngLastRow = Sheets("Data").Cells(Rows.Count, "A").End(xlUp).Row

However in my worksheet "A1" is blank, and the table starts at "A2"

 

[VoG]

In code? Try

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

Edit: I see you added your code as I posted.

 

[Jonmo1]

That code will still give you the last row of column A.
Regardless if A1 is blank or not.

 

[Noz2k]

Yeah, which is why I couldn't work out what was wrong with it.

Just realised that I was clearing the cells before specifying the last row, which is why is wasn't returning what I expected. Have just rearranged the code now and it works fine. Silly mistake. Thanks for answering anyway