Better way of finding last row on sheet
Thank-you all for your very helpful comments - I was missing the obvious (as
usual).
There was some hidden text in row 26 - now works fine
Thanks all
"Bob Phillips" wrote in message
...
"Andibevan" wrote in message
...
Hi,
Can anyone improve on this formula to find the last row of a sheet:-
Sheet1.Range("A65536").End(xlUp).Row
This keeps finding row 26 as the last row when I only have 3 rows of data.
I very much doubt it, this technique doesn't suffer the last used cell
problem that say Ctlr-End suffers. You must have something in A26. Try
?LEN(Range("A26")) in the immediate window
|