| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
sheet1.select will select the index of the sheet
sheets(1).select will select the one to the far left. -- Don Guillett SalesAid Software "DAA" wrote in message ... Thanks a million gentlemen!!!!!!!!!! -----Original Message----- try Sheet1.Select -- Don Guillett SalesAid Software "DAA" wrote in message ... 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. . |
| Reply |
| 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 | |||
Hybrid Mode
