CountIF formula in VBA

[jericho14444]

Hello,
Does anyone know how to write these two formulas in VBA code?

=COUNTIF(Z2:Z77,"<21")
and
=COUNTIFS(F2:F92,">=21",F2:F92,"<+30")

Here is the catch though - The range will not always be Z2:Z77 or F2:F92. The code will always start with Z2 and F2 and then autofill to the bottom.

Thank you!

[AB33]

Gives you a good start

Please Login or Register  to view this content.

[AlphaFrog]

If you reference the entire column, the Countif function knows to only count within the used range of the worksheet. There is no efficiency gain in referencing the specific range of all the column data versus the entire column.

Please Login or Register  to view this content.