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. |
#3
|
|||
|
|||
Hi
sheets(1).select -- Regards Frank Kabel Frankfurt, Germany "DAA" schrieb im Newsbeitrag ... 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. |
#4
|
|||
|
|||
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. . |
#5
|
|||
|
|||
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 |