Dear All,

I have some code that drags some data out of one sheet and summarises
it another by creating an array, then offloading the array.

The new range of data is the base of some array formulas. Because of
this I turn off all calculations during the population of the new range
as each cell that is populated automatically sets the array formula to
recalc - causing much waiting time.

However, when the code completes I am having trouble get the array
formulas to recalc again. Currently I am physically retyping the
formulas to get the result I am after.

Is there a solution to trigger a recalc after the
xlCalculationAutomatic is reset.

eg.
1. I gather an array of data from sheet 1
2. I offload this array to a range in sheet 2 (eg "A1:C100")
3. In sheet 2 I have some array formulas in column "E" that does
calculations based upon the data in the newly populated range
("A1:C100").
4. The array formulas are not being triggered to calc the "A1:C100"
range
5. Currently I have to re-type the formulas to get the results I am
after.

Any suggestions will be most appreciated.

Regards,

andym

Try

Application.CalculateFull

Tim

"andym" wrote in message oups.com...
Dear All,

I have some code that drags some data out of one sheet and summarises
it another by creating an array, then offloading the array.

The new range of data is the base of some array formulas. Because of
this I turn off all calculations during the population of the new range
as each cell that is populated automatically sets the array formula to
recalc - causing much waiting time.

However, when the code completes I am having trouble get the array
formulas to recalc again. Currently I am physically retyping the
formulas to get the result I am after.

Is there a solution to trigger a recalc after the
xlCalculationAutomatic is reset.

eg.
1. I gather an array of data from sheet 1
2. I offload this array to a range in sheet 2 (eg "A1:C100")
3. In sheet 2 I have some array formulas in column "E" that does
calculations based upon the data in the newly populated range
("A1:C100").
4. The array formulas are not being triggered to calc the "A1:C100"
range
5. Currently I have to re-type the formulas to get the results I am
after.

Any suggestions will be most appreciated.

Regards,

andym