Macro to Change Worksheet Formulas

[Bob@Sun]

Hello,

I am wondering if it is possible to change part of a worksheet formula via vba?

In the attached file, sheet 2 holds the data and the named ranges. What I need is to be able to change the formula in sheet2, in the range B4:B6 from:

=SUMPRODUCT(--(RName=$A4),--(RWeek=B$2),RQty)

to

=SUMPRODUCT(--(RName=$A4),--(RMonth=C$2),RQty)


Can this be done with macro?
Please answer only if you have vba solution because in the real file the range with the formulas is big and I do not want to make any changes to its structure.
I just need to be able to switch the formulas in the cells B4,B5 and B6

I would appreciate your help!

[davegugg]

Hows this?:

Please Login or Register  to view this content.

[Bob@Sun]

It is working, but RName=$A4 must change. With this code I get one formula for all rows.

Can you modify that?

Thanks

[Bob@Sun]

I got it!

Please Login or Register  to view this content.

Thanks for the help!