persistent "invalid reference" error message

This is in Excel 2007.

So I have this embedded graph that I'm updating using VB. And I'm in
development on the VB, so occasionaly things blow up and I get invalid
formulas on the graph. Fine. I expect to get the occasional invalid
reference error message.

However, the error message seems to persist after I think I've gotten
rid of the offending part on the graph. For example, I have a routine
that deletes all titles and data series for the graph. And yet the
error message is still there. I open another Excel file then close it,
and invalid reference. I save my workbook and invalid reference. I
switch from one worksheet to another and ivalid reference.

What have I got to do to get rid of this error message? It's going to
make me look pretty bad in front of the client if the app keeps saying
invalid reference.
Socks

On Thu, 12 Jan 2012 12:53:06 -0800 (PST), Puppet_Sock





wrote:
>This is in Excel 2007.

>So I have this embedded graph that I'm updating using VB. And I'm in
>development on the VB, so occasionaly things blow up and I get invalid
>formulas on the graph. Fine. I expect to get the occasional invalid
>reference error message.

>However, the error message seems to persist after I think I've gotten
>rid of the offending part on the graph. For example, I have a routine
>that deletes all titles and data series for the graph. And yet the
>error message is still there. I open another Excel file then close it,
>and invalid reference. I save my workbook and invalid reference. I
>switch from one worksheet to another and ivalid reference.

>What have I got to do to get rid of this error message? It's going to
>make me look pretty bad in front of the client if the app keeps saying
>invalid reference.
>Socks

  This happens when you have a vlookup type code string (or hlookup I
presume), and one of the parameters for the lookup returns a zero or
blank value and the formula cannot complete, or it is set to false, and
should be set to true.