ExcelBanter - Count if in VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Count if in VBA (https://www.excelbanter.com/excel-programming/357159-count-if-vba.html)

Jennifer

Count if in VBA

I would like to count the cells with "Check Record" in col K in VBA code.
Help?

Thanks!

Toppers

Count if in VBA

n = Application.CountIf(Range("K:K"), "Check Record")

"jennifer" wrote:

I would like to count the cells with "Check Record" in col K in VBA code.
Help?

Thanks!

All times are GMT +1. The time now is 10:16 AM.