Countif and VBA

[Guest]

I have the following equation in VBA

SummaryBSheet = lrow - "=COUNTIF($H:$H,0)"

if I enter what's in the "" in an Excel workbook, no problem, when I put it
in the code, I get a type mismatch. What am I doing wrong? I'm sure it's
something simple. lrow works. I've not used SummaryBSheet before

 

[Ron de Bruin]

Hi Barb

You can use
Application.WorksheetFunction.CountIf(Columns("H"), 0)