Error Handling for xlCellTypeFormulas
 

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

Error Handling for xlCellTypeFormulas
 

If you know that there could be errors, you could turn off error checking (for
as short a time as possible), try to do the work, and then turn error checking
back on.

on error resume next
Columns("AQ:BC").SpecialCells(xlCellTypeFormulas, 16).ClearContents
on error goto 0

But using "on error resume next" indescriminately is a very bad idea.

ccfcrup wrote:

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

--

Dave Peterson