View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Jumping to a certain cell

You would want to use an Event macro.

Event Macros, Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm
Worksheet_Activate Event (#ws_activate)
http://www.mvps.org/dmcritchie/excel...tm#ws_activate

which is set up for the current date upon sheet activation
you can limit it to a specific column.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"The Fool on the Hill" wrote in message
...
Dear Excell(ent) users,

I have a file with multiple sheets. In those sheets I work with dates
(dd-mm-yy). What I am looking for is a macro which opens the file in those
sheets at the current date.

For instance 15-03-2007 is in Cell BX3, so when it would be 15-03-2007 when
I open that sheet, the cursor should be in BX3.

Can you help me, please?

Thank you !