Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Direct reference
Hello all,
We are making timesheets for every person to fill in. At present every person needs to goto the cell containing today's Date and start populating against it. What I require is that when the excel sheet is opened it should directly point to the cell containing today's date. and the person does not need to scroll up / down. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Direct reference
Hi Archana,
Following should do the job ... to be added in the worksheet module ... Private Sub Worksheet_Activate() Cells.Find(What:="today()", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False).Activate End Sub HTH Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference with Range Name | Excel Worksheet Functions | |||
How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions |