In VBE, Put cursor on sheet namef4at the top is Name... Now you may
refer to sheet1, sheet2, etc no matter where it is moved to and what
the user changed the name to.

On Dec 13, 10:51*am, Ardy wrote:
Hello All.
it is my understanding that Excel calls an spreadsheet file (*.xls,
*.xlsx) a Workbook and the tabs within are called Worksheet. *Looking
at the VB editor I can see the tabs are ordered as Sheetx(name of the
tab).

Here is my question. is there a way to rename the Sheetx to numbers
starting from 1 to what ever number of exiting tabs. * this way once I
get a file regardless of what the user has done I can assure that the
tabs are ordered from 1 to x. *then it would be easier to reference
the tabs by numbers knowing they will be there.

So essentially I am numbering the tabs starting from 1.

Ardy