Macro to catch cell value

[bhavtoshsharma]

hi all,
i have a 2x2 table in excel and i want to count the number of cells that have a specific "value or text" entered by user.

for below example i want to count the number of cells that have "hi" as a value

C1 C2
a hi
hi b
c d

etc....

is there a way where i can write a handy macro?

thanks for help,

[Andy Pope]

why not use the COUNTIF formula?

=COUNTIF(A1:B2,"hi")

[bhavtoshsharma]

why not use the COUNTIF formula?

=COUNTIF(A1:B2,"hi")

thanks for response; but what if user enter "5. hi" in a cell then this function may not work properly?

[jasoncw]

Going off Andy's formula, you can use:

=COUNTIF(A1:B2,"*hi*")

HTH,
Jason