Hi guys and ladies,
In the VBE when you look at the worksheet names on the left pane. There is the Sheet Number followed by the tab name. --IE:Sheet1(MyTab)-- You can, in a macro use either of these to refer to a worksheet.
So if i have a macro where i want a reference to not change even if the tab is renamed i want to use the "Sheet1" reference.
In these two examples the first doesn't work. The second does. Would you explain a little about this? (why, how to, etc)Worksheets("Sheet1").Select Worksheets("MyTab").Select
Thx