Could someone please tell me how to write or give me a macro that checks to
see if the text "#N/A" is in a cell, and if it is, change the text in that
cell to white??
Thank you very much

If you want this to happen automatically, it would be much more
efficient to use Conditional Formatting. Choose Format/Conditional
Formatting and enter

CF1: Formula is =ISNA(A1)
Format1: Font/White


(substitute your cell reference).


You could use a macro. One way:

Public Sub WhiteOut()
Dim rCell As Range
For Each rCell In Selection
If rCell.Text = "#N/A" Then rCell.Font.Color = vbWhite
Next rCell
End Sub


In article ,
BLW wrote:

Could someone please tell me how to write or give me a macro that checks to
see if the text "#N/A" is in a cell, and if it is, change the text in that
cell to white??

There must be a VBA code but I'd use this:

=IF(ISNA(Formula);Text;Formula))
Then, with conditional formatting, you can set Text to white.

Bart Snel


"BLW" schreef in bericht
...
Could someone please tell me how to write or give me a macro that checks
to
see if the text "#N/A" is in a cell, and if it is, change the text in that
cell to white??
Thank you very much