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.

Worksheets("Sheet1").Select
Worksheets("MyTab").Select
In these two examples the first doesn't work. The second does. Would you explain a little about this? (why, how to, etc)

Thx