Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluate function
Hello,
In an Evaluate statement I use a variable (MyVar) im the middle of the function, something like ddd= Evaluate("expression 1" & MyVar & "expression 2") When MyVar is not numeric I use ddd= Evaluate("expression 1" & Chr(34) & MyVar & Chr(34) & "expression 2") I look for a way to use one Evaluate statement only , both for numeric and non numeric ddd instead of 2 statements with IF Thanks a lot Avi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluate function
One way:
ddd = Evaluate("expression 1" & _ Iif(IsNumeric(MyVar),MyVar, Chr(34) & MyVar & Chr(34)) & _ "expression 2") In article , avi wrote: Hello, In an Evaluate statement I use a variable (MyVar) im the middle of the function, something like ddd= Evaluate("expression 1" & MyVar & "expression 2") When MyVar is not numeric I use ddd= Evaluate("expression 1" & Chr(34) & MyVar & Chr(34) & "expression 2") I look for a way to use one Evaluate statement only , both for numeric and non numeric ddd instead of 2 statements with IF Thanks a lot Avi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help on Evaluate function | Excel Programming | |||
Evaluate function | Excel Worksheet Functions | |||
Evaluate (Variable Function Name)? | Excel Programming | |||
evaluate a function | Excel Programming | |||
EVALUATE Function | New Users to Excel |