Thread: Ctrl+End with VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul D. Simon Paul D. Simon is offline
external usenet poster
  
Posts: 46
Default Ctrl+End with VBA
I believe this 1-line code should do what you're looking for.

ActiveCell.SpecialCells(xlLastCell).Select


or as an alternative, this 1 line should work also.

ActiveCell.SpecialCells(xlCellTypeLastCell).Select

Reply With QuoteReply With Quote