get rid of "A formula in this worksheet contains one or more invalid references"

[Thecyclist]

Hi everyone,
I have a workbook in which there are many charts referring to range names.
The range names have been defined using a combination of "OFFSET" and "Countnumber", such that they change size as the values change.
Sometimes these ranges are empty because there are no values, only a "#NA" in the first cell and excel returns me the annoying message
"A formula in this worksheet contains one or more invalid references".

What can I do to get rid of that?
I know the code

Please Login or Register  to view this content.

but I don't know where to write that to be valid for the whole workbook and forever!

Thanks in advance

[Special-K]

Prevent the error from occurring in the first place, ie

IF(ISNA(formula),"",formula)

[Thecyclist]

as you suggested I eliminated the NA with if formulas, but I still have the message, are you sure that if the range is completely empty the error?
can it be a chart problem which is supposed to chart an empty vector?

don't you know a way for deactivate these kind of messages?

[JosephP]

change the definition of countnumber so it is always at least 1 using
=MAX(current_formula,1)

[Thecyclist]

Sorry Special-k, now it works, probably there were still some problems, now everything seems ok. Thank you

Thanks JosephP for the suggestion!