Evaluate Array Functions in VBA

Question

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?&nbsp;' Run the video by selecting the rows of data&nbsp; &nbsp; &nbsp;For I = IMin To IMax Step IStep&nbsp; &nbsp; &nbsp; &nbsp;Sheets("Setup").Cells(21, 4) = I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' Update row # of data&nbsp; &nbsp; &nbsp; &nbsp;Sheets("Calc").Application.Evaluate ("C3")&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' Attempt to evaluate' =GRIDXYZ(Setup!$B$2:$C$16,Setup!$D$2:$D$16,Calc!$C$2:$G$2,Calc!$B$3:$B$7)&nbsp; &nbsp; &nbsp; &nbsp;Sheets(Cht(Text9)).Activate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' Show graph with new data&nbsp; &nbsp; &nbsp; &nbsp;ActiveChart.Shapes("Text Box 4").Select&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' Update the current time&nbsp; &nbsp; &nbsp; &nbsp;Selection.Characters.Text = (I) &amp; " " &amp; Text0&nbsp; &nbsp; &nbsp; &nbsp;ActiveChart.ChartArea.Select&nbsp; &nbsp;delay (MsDelay)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' Time delay routineNext I

hansvogelaar · Answer

rjarrett62 I don't know if GRIDXYZ (a function from an add-in) can be used in Evaluate.
Try
&nbsp;
        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)")
&nbsp;

Forum Discussion

Evaluate Array Functions in VBA

Share

Resources