persistent "invalid reference" error message

[Puppet_Sock]

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

 

[CellShocked]

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.

 

[Puppet_Sock]

  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.

Thanks for the response. But I don't use vlookup or hlookup
anywhere in my workbook.
Socks