Hi and thanks in advance.

I have some code where I would like to insert a string variable that holds an operator which will be either = or <

The InStr line in the code below results in a Type Mismatch error ...

hi deutz,

x = InStr(1, rng.Value, "ZAC")
If Evaluate(x & strOperator & 0) Then

--
isabelle



Le 2012-05-31 21:26, deutz a écrit :
Hi and thanks in advance.

I have some code where I would like to insert a string variable that
holds an operator which will be either = or<

The InStr line in the code below results in a Type Mismatch error ...


Code:
--------------------

If some condition then
strOperator = "<"
Else
strOperator = "="
End If

If InStr(1, rng.Value, "ZAC")& strOperator& 0 Then


--------------------

Try this instead:

bFound = instr(1, rng.value, "ZAC") 0
if strOperator ="<" and not bFound then

elseif strOperator ="=" and bfound then

end if

Robert Flanagan
Add-ins.com LLC
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel





On May 31, 9:26*pm, deutz wrote:
Hi and thanks in advance.

I have some code where I would like to insert a string variable that
holds an operator which will be either = or <

The InStr line in the code below results in a Type Mismatch error ...

Code:
--------------------

* If some condition then
* strOperator = "<"
* Else
* strOperator = "="
* End If

* If InStr(1, rng.Value, "ZAC") & strOperator & 0 Then

--------------------

--
deutz