Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a way to verify a string is present in 1-column array?
I need to verify than an operator string (part number) input is valid from a
predetermined listing of "acceptable" part numbers without getting #N/A error. Help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a way to verify a string is present in 1-column array?
Maybe you can use application.match()
Dim res as variant 'could be an error dim myArr as variant dim myVal as variant 'could be a number or string myarr = array(1, 2, "abc", "def") myval = "abc" res = application.match(myval,myarr,0) if iserror(res) then 'not found else 'was found end if TAN wrote: I need to verify than an operator string (part number) input is valid from a predetermined listing of "acceptable" part numbers without getting #N/A error. Help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to verify the first char of the string in excel? | Excel Discussion (Misc queries) | |||
How to verify the first char of the string in excel? | Excel Discussion (Misc queries) | |||
How to verify the first char of the string in excel? | Excel Discussion (Misc queries) | |||
Test for char in string & separating if present | Excel Programming | |||
How to verify specific Worksheets are present | Excel Programming |