Ardy explained on 12/13/2011 :
On Dec 13, 12:47*pm, Don Guillett wrote:
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

What Would I do Without this group.......

My Thanks to all. Garry I think you hit the nail on the head.
Meaningful name s are definitely a +. I think I do that. also your
assumption was correct they are numbered unless one gets deleted,
then you run into trouble. I think I have enough to peace together to
get the show running.

Thank You all.

Ardy

Thanks for the feedback!
Best wishes in your endeavour...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc