M, you can do it this way:
Dim T As Long
T = Now()
r = Application.Match(T, Columns(1), True)
Application.Goto Cells(r, 1)
assuming that you are on the sheet containing the dates and they are in
column A.
Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"Smeesh" wrote in message
...
I have Excel 200 in the office and have created a projector booking form.
I
want to improve the worksheet by getting it to open at the current date.
The worksheet (column a) has listed in it the date. Can anyone help with
some vb (or other method - I am not fussy) to open the sheet at the
current
system date.
Thanks in advance
m