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