Add to an Existing formula in a Cell using VBA

[sgltaylor]

Hi,

I am trying to figure out how to do the following:

Assume you have a formula like sum (A1:A5) in cell A6.
What I need to do is add a sumproduct formula to the existing formula using vba.
For example, the formula in cell A6 will be updated to sum(A1:A5)/SUMPRODUCT((C4:C8=B1)*(D4:D8=B2))

Any ideas or suggestions.

Thanks,

Steve

[Paul]

Hi Steve, and welcome to the forum. The VBA would look like this:

Please Login or Register  to view this content.

[alwysonadiet]

I made my own post because my response here, although directly related to the original post, was actually another question and I didn't see an option to delete this post. So sorry.