Slow macro due to formulae being copied in a range of cells

[Themd]

Dear all,

I have written a vba code to:

-calculate a range of cells by copying Formula A to a range.

A B C D
1 FA FA FA FA
2 FA FA FA FA
3 FA FA FA FA

-then summing each column and copying the summed data on row 4 to another sheet.

-Then the vba clears the range and this time enters Formula B to the same range, sums each column at row 4 and copy's it to the same sheet under the results for the previous, Formula A.

Instead of having the formulae in each column and having a separate sheet for each calculation, I thought this would be simpler. However, it is extremely slow.

I was wondering if there is a smarter way of doing this. I thought of arrays, but wasn't sure.

Thanks for your help and time.

Themd

[sous2817]

Can you post what you have so far in your macro? Might be easier to tweak what you have rather than make up a formula and re-invent your process.

[Themd]

If you scroll down you will see the section where I define two formulas and use it to calculate and copy paste.

Thanks for your time.

Please Login or Register  to view this content.

[Themd]

I have redefined a range within the section I would like the formula to be copied to. (A1:GC900) Which is actually, W9.

If I could do a count row on column V9 and copy the formulas until the end of that column instead of going all the way down to 900, it should fix it.

But I do not know how