Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook containing a number of worksheets, some of which contain
weekly data extracted from a database and which are regularly updated, and others perform various calculations on the data to produce reports and graphs. After updating the data I want to be able to visually check the latest week of data entry in one of the worksheets, and am trying to write a macro that will place the cursor on the first cell of the row containing the most recent date (i.e. maximum date value) when the sheet is opened rather than having to scroll down through an increasingly long column each time. I have tried several things without success - I am new to macro writing - can anyone help with a suggestion please? Thanks in anticipation. -- pignick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to get a cell to only update when worksheet is opened? | Excel Discussion (Misc queries) | |||
Formating Cells used code when worksheet opened | Excel Worksheet Functions | |||
Excel not displaying the last active worksheet when opened | Excel Discussion (Misc queries) | |||
Can custom views be opened in a worksheet by other users? | Excel Discussion (Misc queries) | |||
How do I protect a worksheet from being opened inside a workbook | Excel Discussion (Misc queries) |