Hi,

had you posted you array formula then it would have been easier to help but
this may get you going in the right direction.

Range("A1").FormulaArray = "=AVERAGE(IF(C1:C110,C1:C11))"

Mike

"Labkhand" wrote:

Hi All,

In my VB code, I assign different formulas to several columns. If the
formula is not an Array formula, I am okay. But, I have an issue whenever I
am assigning an array formula to a cell.

For an array formula it is required to hold Ctrl + Shift, and press the
Enter key to see the result in the cell.

When I run my code, it inserts the array formula in the cell, but it doesn't
show the result until I manully go to the cell and do the Ctrl + Shift, and
press the Enter combinations.

How can I make the result on this cell be automatically calculated through
the VB code without any manuual process that I am doing?

Thanks for your help in advance.