Hi All

I am running some code that clears all the errors (#DIV/0!) in certain
columns. The code I am using is shown below:

Columns("AQ:BC").Select
Selection.SpecialCells(xlCellTypeFormulas, 16).Select
Selection.ClearContents

The data in columns AQ:BC are dependent on source data from elsewhere.
If I do have errors the code works fine. However when there are no
errors I get a runtime error 1004 - no cells found. From reading
around i guess I need to have an error handler.

Can somebody please help?

Thanks

Rup