Possible to refer to a sheet's object name ?

[kittronald]

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.

 

[Don Guillett]

    Is it possible to refer to a worksheet's object name in a formularather
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