Thread: Detect #N/A or number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Bircher[_2_] Peter Bircher[_2_] is offline
external usenet poster
  
Posts: 11
Default Detect #N/A or number
Hi all

I need to be able to detect whether a cell contains #N/A or alternatively a
number

If Cells(I - 1, HighestPColumnnumber).Number Then . . .

--
Thanks in anticipation

Peter Simonotti-Bircher

SA MEDICAL EQUIPMENT
Tel : +27 31 266 9422
Cell : +27 83 233 1628 - Peter
+27 82 555 1192 - Marcelline
Email:


Reply With QuoteReply With Quote