On Oct 2, 12:05*pm, "Rick Rothstein"
wrote:
I am very happy about your new suggestion.
Now it works as I want.

Really? It works? Exactly what is in your cells? You said your "error" was
#I/T... since #I/T is not a "real" Excel error, I don't see how Claus' code
could do what you want. Anyway, if your cells really have #I/T in them (as
constants, not formulas), then this code should replace each one of them
with the empty string, thus clearing those cells...

Seems that #I/T is a real error (just not in the English version
maybe...)

http://office.microsoft.com/da-dk/ex...010342325.aspx