converting COUNTIFS formula to macro

Hi all

i have been setting up a macro with the kind help of a forum member the past week and it now works great.

I am wanting to add a formula to my worksheet which I want in the macro, but I am having a bit trouble putting it together. It is as follows:

Please Login or Register  to view this content.

I tried this, which is similar to my countif formlas in the macro but it doesnt work.

Please Login or Register  to view this content.

Any help would be greatly appreciated. I have clicked solved on my previous thread regarding this as I think it may be better aswered on this forum. This was the previous thread:


http://www.excelforum.com/excel-prog...-to-vba-2.html

thanks
gemma

this is the macro i want to use it in:

Please Login or Register  to view this content.