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!

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!

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!