count z in range

[zak.horrocks]

Hi,

I am trying to count the number of Z's in my range using vba, with msgbox.

I have set my range but cannot get the code to count just Z's.

Any ideas?

Thank you

Z

[S O]

Why do you need VBA? just use a =COUNTIF() formula

[zak.horrocks]

I have a VBA code that I am trying to add the countif formula to, to automate the process.

[S O]

Dim numberOfZ As Integer
numberOfZ = WorksheetFunction.CountIf(myRange, """*z*""")

You can access worksheet functions through the WorksheetFunction class - don't forget to escape your quotation marks though.

[S O]

WorksheetFunction.CountIf(myRange, """*z*""")

You can access worksheet functions through the WorksheetFunction class - don't forget to escape your quotation marks though.

[zak.horrocks]

Thanks S O. That works great, with the msgbox.

Z