View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David
 
Posts: n/a
Default 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