Clear N/A from any cells in Column B:P

[Sal1]

I want to create a macro that will clear “N/A” from any cells in Column B:P. What I have so far I pasted below however when I try to run it I receive an error message that reads ‘‘Wrong number of arguments or invalid property assignment’ Can you help me get this to work?

Please Login or Register  to view this content.

[DonkeyOte]

Do you mean "N/A" as a literal string or #N/A as in result of formula error ?

If the latter, do you

a) want to override the formulae

b) have other error values in the range which should persist ? (eg #VALUE! etc...)

A sample file might help clarify the above.

[Sal1]

Hi DonkeyOte, my apologies for not being clearer. I mean just the text N/A.

[DonkeyOte]

Perhaps then:

Please Login or Register  to view this content.

[Sal1]

Exactly, the result I needed. Thank you!

[watersev]

Please Login or Register  to view this content.

[DonkeyOte]

@waterserv, making a few assumptions there... [last row] ... though admittedly perfectly reasonable ones