View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default 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