Try date()
Now() gives you information about the date and time
Date() gives you just date information.


"Smeesh" wrote in message
...
Hi Ross (and anybody else who wants to help!),

Thanks for the reply, however I had tried the Today() subfunction and
could
not get it to work.

The VBA I have is:
Private Sub Workbook_Open()
Sheets("bookingsheet").Activate
Range((B4:B1454)=Today()).Select
End Sub

I get a compile error because of the :. Am I on the wrong track?

"ross" wrote in message
om...
Easy!

the formuals are
=Today()
of for a little more info
=now(),

these can be called from vba in the usally way

Enjoy
Ross