I have some code that I want to use to check for the value of #N/A in a cell... it is...
If ActiveCell.Value = "#N/A" Then
However... I keep getting a "type mismatch" when I try to run it. And yes, the cell valus is #N/A.
I have even tried...
If ActiveCell.Value = "N/A" Then
To no avail. Any help in pointing me in the right direction would be greatly appreciated.