VBA and ISNA# Format

[Preatorian]

Hi, I have this piece of code that returns a value with #NA sometimes when there is no value. How can I make this #NA not show when there is no value.

Here is the piece of code.

Please Login or Register  to view this content.

Thanks...

[shg]

An easy way is to use conditional formatting to set the font color to the cell color, with a formula of =ISNA(A1)