FinalRow / Rows.Count not working

[Bunter]

Hi
Ive got the Excel 2016 VBA and macros book and am learning lot but one huge frustration, the key line .... FinalRow = Cells(Rows.Count,1).End(x1Up).Row
does not work for me. I get "Run-time error '1004': Application-defined or object-defined error". Is it something basic that I'm not doing? Please help.
Cheers. Bunter

 

[B___P]

amend code this way:.
FinalRow = Cells(Rows.Count,1).End(xlUp).Row

it is L not 1

hope this helps

 

[Bunter]

amend code this way:.
FinalRow = Cells(Rows.Count,1).End(xlUp).Row

it is L not 1

hope this helps

That helps, very much appreciated, Ta