Keep tab reference in VBA if name changes

[Chewyhairball]

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

 

[Chewyhairball]

Ha! figured it out 30 seconds after posting this.

Sheets("Sheet1").Select

would be

sheet1.range

 

[Chewyhairball]

sorry.... i meant

sheet1.select