View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta Victor Delta is offline
external usenet poster
 
Posts: 33
Default Macro to jump to today's date

Hi

I have an Excel spreadsheet which includes, in Col A, a list of all 365 days
of the year.

When opening the spreadsheet, using an auto_open macro, I would like the
opening view to include today's date (perhaps a few rows down from the top).

Can anyone please recommend which functions I need to use in the macro to
make the spreadsheet open in this way.

Many thanks,

V