How to search for "#N/A" in Excel VBA

Posted to microsoft.public.excel.programming

viking4020 viking4020 is offline

external usenet poster

Posts: 1

How to search for "#N/A" in Excel VBA

I wish to write vba code that finds occurrences of #N/A, #NAME, etc in Excel
spreadsheets.

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
search for text "beginning with" "containing" wildcards	David H	Excel Worksheet Functions	1	January 13th 10 01:24 PM
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG"	MAHMOUD	Excel Worksheet Functions	5	September 6th 09 06:04 PM
How do I change the Excel "search" default to WORKBOOK & DATA?	danny bromberg	Excel Discussion (Misc queries)	5	July 5th 09 06:44 AM
=IF(ISERROR(SEARCH("insurance",A125,1)),"","*")	cynichromantique	Excel Worksheet Functions	9	September 25th 08 09:49 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell	Steve Kay	Excel Discussion (Misc queries)	2	August 8th 08 01:54 AM

All times are GMT +1. The time now is 04:20 PM.

About Us