Thread: how to find the last line?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Kent Kent is offline
external usenet poster
  
Posts: 4
Default how to find the last line?
Here you go...

iLastRow = UBound(ActiveSheet.UsedRange.Value2, 1) +
ActiveSheet.UsedRange.Row - 1

iLastColumn = UBound(ActiveSheet.UsedRange.Value2, 2) +
ActiveSheet.UsedRange.Column - 1

-Kent


italo wrote:
how can i find the number of the last line of a sheet??
urgent, please!

Reply With QuoteReply With Quote