That would make sense. Im guessing that the two sheets that returned
different values (5 and 17) are the ones that share the same name.
Other sheets would then return a #REF! error as they wouldn't know
WHICH name I was actually meaning.
Ill take a look at that download, sounds handy:)
(Just verified the existence of the same name on two worksheets... )
Dave Peterson wrote:
Maybe you have a workbook level name and multiple worksheet level names that all
share the same name.
Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:
You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
It'll make it much easier to verify your names.
S Davis wrote:
Is there a limit to the number of named ranges? I am running into
errors now with my large (large) workbook here, which contains a ton of
named ranges just to make things easier for me.
For instance, a simple formula such as this:
=COUNTA(RBCJobTitle06)-COUNTIF(RBCJobTitle06,"")
... which returns "5" on the sheet in which the named range resides in,
returns 17 on another worksheet, and a #REF! error on still another
worksheet.
Is my workbook messed up?
--
Dave Peterson