Forum Discussion
Evaluate Array Functions in VBA
I have a loop in VBA to contour plot temperature data with an array function interpolation. How do I evaluate (Shift-Cntl-Enter) the array inside the macro? ' Run the video by selecting the rows ...
rjarrett62 I don't know if GRIDXYZ (a function from an add-in) can be used in Evaluate.
Try
Sheets("Calc").Application.Evaluate("=GRIDXYZ(Setup!$B$2:$C$16,Setup!$D$2:$D$16,Calc!$C$2:$G$2,Calc!$B$3:$B$7)")