View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
awvanheerde awvanheerde is offline
external usenet poster
 
Posts: 2
Default how do I automatically jump to the present date in a roster?

a sample formula would be great !
it is all about a single sheet but with rather large cells. Therefor not all
dates of a month (ore more) are visible at the same time and I have to scroll
to the present date to see my tasks in the roster.
First columm indicates the datefield, while the first row indicates the
people working the roster.
Hope this helped a bid more?

Thanks



"Toppers" wrote:

Look at using the "Workbook_Open" event with suitable VBA code. More detail
is required if you want sample code i.e. what data (the date) is where in
what worksheet.


"awvanheerde" wrote:

Is it possible to jump direct to the present date after opening a month-roster?