Customizing Macros
Hi,
I am making a spreadsheet with different tabs for different projects i am running. I have made a front page, now i want to be able to type in the name of the sheet and the macro should be able to pick that name up and go to that sheet and pick the values as i have recorded it to. Therefore keeping the cell references same but changing the sheet. All help will be appreciated. Thanks |
Customizing Macros
First Select sheet, then use ActiveSheet.Range(...)!
If sheet name is entered, say, in A1, then Worksheets(Range("A1").Value).Select .... ActiveSheet.Range(...) Regards, Stefi €˛Haseeb€¯ ezt Ć*rta: Hi, I am making a spreadsheet with different tabs for different projects i am running. I have made a front page, now i want to be able to type in the name of the sheet and the macro should be able to pick that name up and go to that sheet and pick the values as i have recorded it to. Therefore keeping the cell references same but changing the sheet. All help will be appreciated. Thanks |
All times are GMT +1. The time now is 12:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com