Possible to refer to a sheet's object name ?


K

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.
 
Ad

Advertisements

D

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
 

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

Top