Easy question: Have macro ignore #N/A
 

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


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=526860

Easy question: Have macro ignore #N/A
 

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Paul987" wrote in
message ...

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


--
Paul987
------------------------------------------------------------------------
Paul987's Profile:
http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=526860

Easy question: Have macro ignore #N/A
 

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

--
Regards,
Tom Ogilvy


"Paul987" wrote:


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


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=526860