find cell with today's date
?B?SmFtZXMgRA==?= wrote
my spreadsheet has column A consisting of each date in 2006. I would
like my spreadsheet, upon opening, to go to the row with today's date
in column A and move the spreadsheet up so that is the top row below
my freeze line currently at row 3. Can I do this without visual basic?
How?
Private Sub Workbook_Open()
Application.Goto ActiveSheet.Columns(1).Find(Date), 1
End Sub
--
David
|