| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro, select Sheet "Number", NOT Sheet Name
Hi,
My macro reads: "Sheets("01-Nov-04 Portfolio Summary").Select" (referring to Sheet1). How can I write the macro so Sheet1 will be selected? I have to change my macro everyday because sheet1's name changes everyday. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select sheet with VB code | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Macro for multiple charts | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Threaded Mode
