a simple macro
 

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

a simple macro
 

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??

a simple macro
 

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