Error after running macro

I have a sheet that calculates some times. In some places i get an error. Which is represented like this : ##########

If i search for "#" with the option to look in values, i can find the cells, but the find/replace looks only in formulas so it does not find these cells.

I have this macro

Please Login or Register  to view this content.

Macro 2 searches for the cell and clears the contents. But i get this error after running the macro:

Runtime Error 91 : Object variable or with block variable not set


The macro seems to do it's job (clearing the content of the cells), but I need to get rid of the error.

Thanks for the help

you must find out why that #### occurs. sometimes it may be due to column width is not enough.

you study the formula which gives this error and revise it if necessary