View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alexey[_3_] Alexey[_3_] is offline
external usenet poster
 
Posts: 11
Default 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!