Chewyhairball
Active Member
- Joined
- Nov 30, 2017
- Messages
- 312
- Office Version
- 365
- Platform
- Windows
Hi Guys
I dont know if this is possible but can you keep a vba reference to a particular sheet even if you change the name of the tab.
I have tried using the sheet1,2,3,4 etc instead of the name i have given it but that doesnt work.
I just wondered if there was some dynamic way of doing this if i change the name of a sheet without having to go into the code and update the name there.
thanks
Rory
I dont know if this is possible but can you keep a vba reference to a particular sheet even if you change the name of the tab.
I have tried using the sheet1,2,3,4 etc instead of the name i have given it but that doesnt work.
I just wondered if there was some dynamic way of doing this if i change the name of a sheet without having to go into the code and update the name there.
thanks
Rory