Thread: Get Last Row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
efi[_8_] efi[_8_] is offline
external usenet poster
 
Posts: 1
Default Get Last Row

Hi,
How can I retrieve the last row in a specified colum that full with
information?

I tried to use in Sheet2.Cells.SpecialCells(xlLastCell).Row
but in big numbers it flew.
thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/