Evaluate function in VBA

[SanjayGMusafir]

Hi Experts
Got stuck up at a place

I'm using following function in VBA to get amounts in last 2 hours

x9 = Evaluate("SUMIFS(Visits[Fees],Visits[VDt],TODAY(),Visits[VTm],">="&NOW()-TODAY()-(2/24))")

The challenge is when VBA runs, it automatically adds space(s) before and after ">=" as " >= "

x9 = Evaluate("SUMIFS(Visits[Fees],Visits[VDt],TODAY(),Visits[VTm]," >= "&NOW()-TODAY()-(2/24))")

Thus resulting in calculation error.

Please help or give a workaround.

Thanks in Advance

 

[Alex Blakenburg]

Hi Sanjay,

When you convert the formula to Evaluate you need to double up on the quotes inside the formula.

x9 = Evaluate("SUMIFS(Visits[Fees],Visits[VDt],TODAY(),Visits[VTm],"">="" &NOW()-TODAY()-(2/24))")

 

[SanjayGMusafir]

Thanks a lot @Alex Blakenburg it did the magic