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. |
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. |
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. . |
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. . |
All times are GMT +1. The time now is 04:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com