How to get the count of value and row number and column number

[destiny4me]

I have a spreadsheet where the value "NAME" is appearing multiple times in different cell. How can get the total count and row number column number of each. Attached the spreadsheet for reference.

[NeedForExcel]

Please find the file attached.

Let me know if this is ok?

Thank You,

Deep

[destiny4me]

yep... it is perfect. Thanks Deep

[jolivanes]

You might want to change these lines

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[NeedForExcel]

Hey!

Thank You for the suggestion.

What does that "*" exactly do?

It made the code so much more faster..

[jolivanes]

It is the wildcard for "Zero or more characters"
You can use several in vba. Type "wildcard characters" in the vba help and you'll get them all.
It has the advantage that the code does not have to check cells that are outside the used area or that you have to change the row or column numbers.

[NeedForExcel]

Ok Thank You,

Ill search for it.. Cheers!

Deep