Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 - find todays date
I am trying to create a macro to find todays date in a worksheet and then go
to that cell. Any help with this is most appreciated. Thank you. -- Richard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 - find todays date
Look at Find in the VBA help.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Richard" wrote in message ... I am trying to create a macro to find todays date in a worksheet and then go to that cell. Any help with this is most appreciated. Thank you. -- Richard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 - find todays date
Try:
Sub tdayy() Dim d As Date d = Int(Now()) Dim r As Range For Each r In ActiveSheet.UsedRange If r.Value = d Then r.Select Exit Sub End If Next End Sub -- Gary's Student "Richard" wrote: I am trying to create a macro to find todays date in a worksheet and then go to that cell. Any help with this is most appreciated. Thank you. -- Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
where can i find Formulas for excel 2000? | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Setting today's date automatically in Excel. | Excel Worksheet Functions |