Thread: Find the last Cell in a column in VB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Coder1215 Coder1215 is offline
external usenet poster
  
Posts: 12
Default Find the last Cell in a column in VB
Or more simply:

LastRow = range("C:C").SpecialCells(xlCellTypeLastCell).Row

regards

Reply With QuoteReply With Quote