Hello,

I have a Target Value macro set to run automatically and clear a cell if it
finds the zero value. It works but not quite the way I was hoping.

The Target Value is running on a page (€œFront Page€�) that is based on a set
of cells linked from another page (€œData Page€�). Once €œData Page€� is
cleared, a zero value appears on the €œFront Page€�. Since this change is
brought about by the page value being removed vs. being entered, it does not
detect the change.

Is there something I could do that might bring about better results to
detect the value change?

Thank you €“ Jenny B.