Sumproduct with column variable

[syedyaamin]

Dear Gurus,

I'm just starting to use excel macro and in need of some advice to move forward. My main aim is to have a sumproduct with dynamic column range.
The below codes works so far but when i tried to change the column as dynamic it's not working.

Please Login or Register  to view this content.

Then i change the following
cell(1, 2).Formula = "=SUMPRODUCT((BUDGET!A5:A" & EndRow & "=A" & CurRow & ")*(BUDGET!$B$5:$B$3889=C2)*(BUDGET!$C$5:$C$3889=D2),BUDGET!$F$5:$F$3889)"

Really appreciate any help given.

Regards
Min

[syedyaamin]

It's ok managed to to get it working.