Better way of finding last row on sheet
The first question is, is there anything in cell a26? This procedure will
stop at anything
Ashman
"Andibevan" wrote:
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.
Any ideas?
Andi
|