Names, indexes and codenames can all be changed. Since codenames are least
likely to be changed by the user I'd use them.

--
Jim
"Bassman62" wrote in message
...
| In Excel2007;
| In past threads I've read conflicting comments re. referencing sheets by
| number or code name.
| In VBA, how can I refer to the same sheet every time regardless of the
| sheets code name or position?
| Note the name or position may change often.
| Thanks.
|
| Dave
|