The worksheet has an index number, which start at 1 for the first sheet, 2
for the second, and changes if you move the sheets.

But better yet, they have a codename, which you can change in the VBIDE, and
which doesn't change as sheets move, or as a user renames the Excel name.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Phil" wrote in message
...
Do the worsksheets have a fixed identifier in addition to it's worksheet
name. ie/ is the first worksheet always 1 etc. If so, how can you
identify
the worksheet in this way.