Is(Error)

[Henry]

Hi: I've seen several Wizards that "blank out" cells with the various IsErrors, i.e. #NA, #Value. I can't see the VBA behind it however. Can anyone provide a Macro that I can Cut and Paste to set up a new Macro. Can the Macro have an option of replacing the Error with other data, not just blanks:
Thanks for the help!