Thread: Creating a Macro to take me to first cell of the first sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default Creating a Macro to take me to first cell of the first sheet
Under the workbook_open event use this line of code
Sheets(1).Range("A1").Activate

Charles Chickering
xl Geek

Rob wrote:
I am looking to create a macro which enables me to open a file at the cell A1
on the first sheet, no matter where I was when i closed the file.

Reply With QuoteReply With Quote