Thread: Better way of finding last row on sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andibevan[_2_] Andibevan[_2_] is offline
external usenet poster
  
Posts: 128
Default Better way of finding last row on sheet
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


Reply With QuoteReply With Quote