Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a cell when Excel opens
I have something similar for one of my workbooks (in a
standard module): Sub Auto_Open() Dim a As String Dim rng As Range a = Format(Now, "m/d/yyyy") Set rng = Sheets("Sheet1").Range("A:A") Set rng1 = rng.Find(What:=a, After:=Range("A1"), _ LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByColumns, _ SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False) If Not rng1 Is Nothing Then rng1.Select End If End Sub -- HTH Jason Atlanta, GA -----Original Message----- I have a spreadsheet with column A containing all the days of the year in mm:dd:yyyy:ddd format. I want the focus to go to the cell containing today?Ts date for any day the spreadsheet is opened. I want this to run automatically when the spreadsheet opens. Thanks in advance for your help. -- Rick . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opens in Autosave.How do I delete it so it opens in Book1? | Setting up and Configuration of Excel | |||
Excel file opens and opens and opens | Excel Discussion (Misc queries) | |||
clicking .XLS file opens Excel 2003 but doesn't find the file | Excel Discussion (Misc queries) | |||
Excel opens correct view - web (used frontpg) opens it wrong | Excel Discussion (Misc queries) | |||
Personal workbook opens when Excel opens | Excel Discussion (Misc queries) |