Need help on Evaluate function

[Alexey]

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!

 

[Bob Phillips]

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]

Thanks

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)