Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 22nd 11, 09:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 162
Default 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.



  #2   Report Post  
Old August 23rd 11, 11:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1,522
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make camera object refer to dynamic range Mica Excel Discussion (Misc queries) 0 March 27th 10 12:14 AM
Printing Sheet's Name Gingit Excel Discussion (Misc queries) 7 November 10th 08 09:13 AM
how to get sheet's number it's name alekm Excel Discussion (Misc queries) 2 January 30th 07 11:32 AM
Check if sheet's name is a number linglc Excel Discussion (Misc queries) 1 July 13th 06 01:48 AM
Tab Name Shown In Another Sheet's Cell jbtenor1 Excel Discussion (Misc queries) 1 October 26th 05 08:52 PM


All times are GMT +1. The time now is 11:43 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017