Using a Sheet Name
Hello,
I am using the following code to name a new sheet: Dim sheetName sheetName = ActiveCell.Value Sheets("Sheet1").Select Sheets("Sheet1").Name = sheetName My macro gets a value from the 'Main' worksheet. It opens a new sheet and pastes that value into the new sheet. It then uses the code above to name the sheet. When I go back to the 'Main' worksheet I want to get another value and then go back to the worksheet I just created using sheetName (because that is the name of my new worksheet). I am doing this because I want to take all same values and put them on one sheet. That value becomes the sheet name. When the value changes I will create a new worksheet and that value becomes the new worksheet name (sheetName). I tried using something like: Sheets(sheetName).Select sheetName still has the value of the worksheet name. But it doesnt like the sheetName. Any help would be great. Thanks |
Using a Sheet Name
Seems like that should work without a problem. If your code isn't too
long, maybe you could post more of it here, along with some example sheetNames you are using. Mark tedd13 wrote: Hello, I am using the following code to name a new sheet: Dim sheetName sheetName = ActiveCell.Value Sheets("Sheet1").Select Sheets("Sheet1").Name = sheetName My macro gets a value from the 'Main' worksheet. It opens a new sheet and pastes that value into the new sheet. It then uses the code above to name the sheet. When I go back to the 'Main' worksheet I want to get another value and then go back to the worksheet I just created using sheetName (because that is the name of my new worksheet). I am doing this because I want to take all same values and put them on one sheet. That value becomes the sheet name. When the value changes I will create a new worksheet and that value becomes the new worksheet name (sheetName). I tried using something like: Sheets(sheetName).Select sheetName still has the value of the worksheet name. But it doesnt like the sheetName. Any help would be great. Thanks |
All times are GMT +1. The time now is 09:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com