| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference sheets named by DAY
How do I reference the sheet named 20 (for the day of the month), then tomorrow the With Sheets("20") will be With Sheets("21")?
Sub Macro1() With Sheets("20") '.do stuff End With End Sub On the worksheet in a cell =Today() and then custom formatted "d" returns 20. Tomorrow I presume it will return 21. How do I make that happen in the code? Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List Sheets excluding sheets named ***-A | Excel Discussion (Misc queries) | |||
| Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible? | Excel Programming | |||
| Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
| Named Reference | New Users to Excel | |||
| Reference a named range | Excel Programming | |||
Threaded Mode
