Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on Evaluate function
Hello,
I am trying to use next statement Dim i as Variant i = Evaluate("IFERROR(MATCH(1,(year=" & year & ")*(week=" & week & ")*(project=" & project.Value & "),0))),-1") and always receive Error 2015 Could you please help me understang what I am doing wrong and where I can find errors descriptions? Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on Evaluate function
i = Evaluate("IFERROR(MATCH(1,(year=" & year & ")*(week=" & week & _
")*(project=" & project.value & "),0)),-1") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alexey" wrote in message ... Hello, I am trying to use next statement Dim i as Variant i = Evaluate("IFERROR(MATCH(1,(year=" & year & ")*(week=" & week & ")*(project=" & project.Value & "),0))),-1") and always receive Error 2015 Could you please help me understang what I am doing wrong and where I can find errors descriptions? Thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on Evaluate function
Thanks
"Bob Phillips" wrote: i = Evaluate("IFERROR(MATCH(1,(year=" & year & ")*(week=" & week & _ ")*(project=" & project.value & "),0)),-1") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alexey" wrote in message ... Hello, I am trying to use next statement Dim i as Variant i = Evaluate("IFERROR(MATCH(1,(year=" & year & ")*(week=" & week & ")*(project=" & project.Value & "),0))),-1") and always receive Error 2015 Could you please help me understang what I am doing wrong and where I can find errors descriptions? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Evaluate function | Excel Worksheet Functions | |||
Evaluate (Variable Function Name)? | Excel Programming | |||
Using AND function to evaluate cells | Excel Worksheet Functions | |||
evaluate a function | Excel Programming | |||
EVALUATE Function | New Users to Excel |