| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Inserting variable into code
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting variable outputs into different ranges | Excel Programming | |||
| Using variable name as a value for inserting a row | Excel Programming | |||
| Inserting Variable Number of Rows | Excel Programming | |||
| inserting a variable into VB | Excel Programming | |||
Threaded Mode
