Deleting cells in Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MSHO - 22 Feb 2006 17:09 GMT

I have a macro that compares two sets of data. Sometimes there isn't data and
so there is a #DIV/0! symbol. How do i go through the cells and delete all of
these?

Thanks in advance

Reply to this Message

Ron de Bruin - 22 Feb 2006 17:23 GMT

Try this for column A

With Columns("A:A")
On Error Resume Next
.SpecialCells(xlCellTypeFormulas, 16).ClearContents
On Error GoTo 0
End With

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>I have a macro that compares two sets of data. Sometimes there isn't data and
> so there is a #DIV/0! symbol. How do i go through the cells and delete all of
> these?
>
> Thanks in advance

Reply to this Message