#1. No. Those kinds of formulas wouldn't need to change.
#2. You may find a way, but it'll probably slow excel down--and it'll be easy
to make mistakes.
#3. Why do you have sheets changing names so often?



Robert Crandal wrote:

Cell formulas that refer to other sheets usually look like
this:

=Sheet2!A1 ' Get cell A1 from Sheet2

However, what if someone changed the name of the
Sheet2 tab to something like "ThisIsMyTab"??? Does that
mean I would have to manually change all possible formulas
to the following:

=ThisIsMyTab!A1

?????

I'm mostly curious if there's a way to use formulas that
do not strictly rely on the names of always changing
tab sheet names.

thank you

--

Dave Peterson