Refer to sheets without using tab name??


Robert Crandal

Cell formulas that refer to other sheets usually look like

=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:



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





The best way is to test it by yourself.

In Excel 2007, formulas that refer to another sheet (in the same workbook)
will be automatically changed by excel if you change the name of any sheet
of the workbook.

Paul E

I have not tested this, but it would seem that you could use a range name w/
Global scope. Even if this was just used to select the sheet and make it
active, it would be a good anchor. Once active, you could get the sheet name
and cobble together the formula using a variable w/ the sheet name it it.



Dave Peterson

#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?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question