Thread: Easy question: Have macro ignore #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul987[_19_] Paul987[_19_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote