Thread: Determining the last row in a spreadsheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Determining the last row in a spreadsheet
Sub Tester2()
Set rng = Cells.SpecialCells(xlLastCell)
MsgBox rng.Row

End Sub


--
Regards,
Tom Ogilvy

"Al Lind" wrote in message
...
I am writting a VB application that reads in an Excel
Spreadsheet. I need to determine the last row for
processing. I can't find the property anywhere. Is there
a method for doing this?


Reply With QuoteReply With Quote