I'm getting a type mismatch (Runtime Error 13) with this code. What I want it to do is delete the contents of the cell if it contains 'N/A'.
Conditional Text Deletion From Cells
-
-
-
-
Re: Conditional text deletion from cell
Do the cells actually contain #N/A? That would cause the Type Mismatch error. If so, change the "N/A" in Simon's code to "#N/A"
Regards,
Rory -
Re: Conditional text deletion from cell
Rory i assumed it wasn't #N/A as thats the result of a formula that hasn't got any alues to work with and can be cured at sheet level with the ISNA function within the formula.
-
Re: Conditional text deletion from cell
Simon,
They might also be left over from a copy/paste special operation?
Regards,
Rory -
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!