Cell Address variable in a formula help

[alexduy]

Can someone help me modify this formula vba?

How come the code ActiveCell.Formula = "=COUNTIF(VariableTop:VariableBottom)" doesn't work?

[Mad-Mizer]

enter the formula where?

Never mind, I see you want it in the active cell

[JOHN H. DAVIS]

Your formula has a circular reference, and COUNTIF needs a criteria.

Please Login or Register  to view this content.

[mikerickson]

One reason the OP code doesn't work is that COUNTIF requires two arguments, the OP is only giving it one range.

Try

Please Login or Register  to view this content.

[alexduy]

Thank you all, it was helpful.