Is it possible to refer to a worksheet's object name in a formula rather
than it's display name ?

For example, Sheet1 has been renamed to Data.

On Sheet2, there are formulas that count errors on the Data worksheet
using COUNTIF (i.e., =COUNTIF(Data!$A$1:$E$25,"Error")

When saving the Data worksheet to another name, the formulas on Sheet2
recalculate and add about a minute to the file save time.

When writing the formula above, is it possible to reference Sheet1
instead of Data ?



- Ronald K.

On Aug 22, 3:59*pm, "kittronald" wrote:
* * Is it possible to refer to a worksheet's object name in a formula rather
than it's display name ?

* * For example, Sheet1 has been renamed to Data.

* * On Sheet2, there are formulas that count errors on the Data worksheet
using COUNTIF (i.e., =COUNTIF(Data!$A$1:$E$25,"Error")

* * When saving the Data worksheet to another name, the formulas on Sheet2
recalculate and add about a minute to the file save time.

* * When writing the formula above, is it possible to reference Sheet1
instead of Data ?

- Ronald K.

You would have to do this using a UDF or a regular macro