|
|
#2
07-31-2012, 09:59 PM
|
||||
|
||||
Hi apolloman,
You could use an IF test to validate the formula's output, THEN suppress if an error, ELSE output if valid. PS: If you used OFFSET formulae for the referencing, no errors would be generated, just 0s - which you could configure your workbook to suppress.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Interactive worksheets on the web | beingbobbyorr | Excel | 1 | 08-22-2011 05:32 AM |
 Merge from 2 excel worksheets
|
apolloman | Mail Merge | 2 | 06-02-2011 04:16 AM |
|
Relinking excel worksheets
|
iffy | Excel | 2 | 01-07-2011 01:53 PM |
|
Linking text between worksheets
|
AndrewsGram | Excel | 1 | 03-09-2010 01:26 PM |
| Help with worksheets on Word | eballi | Word | 4 | 11-18-2009 05:17 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode