VA help to enter array formula

[asad]

Hello All,

I am trying to enter following array formula using VBA. But it does not change the lookup cell. Can someone please help me out?

Range("C6:C29").Formula = "=ROUND($J$1*SUM(IF($P$6:$P$293=[B]A6[/B],[COLOR=#FF0000][/COLOR]IF(MONTH($Q$6:$Q$293)=MONTH($E$1),$R$6:$R$293))),0)"

"A6" in the above formula need to change to A7, A8 and so on.

Any help is appreciated.

Asad

 

[asad]

Thanks to all of you guys for helping me out.
Now I have two working solutions

Regards
Asad

 

[Trebor76]

You're welcome. I did try the fill down method but couldn't it work either

If you have large datasets the fill down method would be the way to go.

Regards,

Robert