Jun 12th, 2001, 02:07 PM
Use VBA to locate a cell in Excel (Find)
I have a workbook with several worksheets. One of the worksheets has a list of (consecutive) dates. What I'd like to do is each time the workbook is opened the worksheet with dates on (let's call it "diary") is opened as default. Then the cell with today's (system) date is automatically selected. It sounds simple and I've tried using a macro to do it
Cells.Find(What:=Date, After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
It doesn't seem to work though. Is there a better way?
Click Here to Expand Forum to Full Width