Thread: change the number of rows to a variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Raman325[_18_] Raman325[_18_] is offline
external usenet poster
  
Posts: 1
Default change the number of rows to a variable

Use:
ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastC ell).Row

This returns the number of the last used row in a worksheet


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=395920

Reply With QuoteReply With Quote