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

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.

yep... it is perfect. Thanks Deep

You might want to change these lines

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

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.