Recalculating Array Formulas

A

andym

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array VLOOKUP lookup_Value does not increment 3
Copy Array to Array, how to and should I? 13
ERROR 400 on identical codes different range 8
Cell values to an array, then array transpose to another workbook 8
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
Array code only works on selected sheet 14
When found add it to the last and display total in Msgbox 23
Search an array of sheets for an array of numbers & return count of numbers 11

Top