Possible to refer to a sheet's object name ?
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. |
Possible to refer to a sheet's object name ?
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 |
All times are GMT +1. The time now is 11:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com