Now how would a formula be able to recognize that some text is a sheet name?

BTW how is it used? As a literal in the formula or is the name in a cell as
text?

If there is something that identifies the text (or part of the formula)
exclusively as it being meant as an address, you can use Find/Replace or
Chip's tip

--
Kind regards,

Niek Otten

"Robbyn" wrote in message
...
Actually it is an indirect() function. Grin.

"Niek Otten" wrote:

Unless it is used in an INDIRECT() function

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
You don't have to.
If you change the sheetname, all formulas (in the same workbook) will
be
adjusted automatically.

--
Kind regards,

Niek Otten

"Robbyn" wrote in message
...
Greetings! Is it possible to change all instances of a page name from
1A! to
2A! in all formulas on a page with a macro? Or is this just silly?

TIA,

Robbyn