Easy question: Have macro ignore #N/A

[Paul987]

How do you ignore #n/A values with macros? Can I have it only look at
numbers? I just need a quick way to tell it to move along, and not
worry about the line with an #N/A value. TIA
Paul

 

[Bob Phillips]

If IsError(ActiveCell.Value) Then
MsgBox "error"
End If


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

set rng = columns(1).Specialcells(Formulas,xlNumbers)
for each cell in rng

or

for each cell in selection
if not iserror(cell) then

end if
Next