Posted to microsoft.public.excel.programming

Peter Bircher[_2_] Peter Bircher[_2_] is offline

external usenet poster

Posts: 11

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How To Detect A Negative Number In A Cell	Minitman	Excel Worksheet Functions	7	March 13th 08 04:12 PM
How to detect use of DSNs?	Paul Martin	Excel Programming	0	May 30th 06 02:43 AM
How to detect row number of selected cells?	Ivan	Excel Programming	1	May 9th 06 05:43 AM
how to detect paste	mjb267	Excel Programming	3	April 6th 04 07:54 PM
How to detect current active sheet number	Mike Chen	Excel Programming	3	April 3rd 04 04:41 PM

All times are GMT +1. The time now is 10:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us