Counter for inputbox result

[Devianey26]

I have a macro that displays data based on the name placed in an inputBox. The names are in a range, as the code loops thru the range I need to count how many times the name (that was supplied in the inputbox) appears

---

. Any suggestions?

[mehmetcik]

This Macro finds all occurrences of the word "Select" in your selected range.

It then Selects all those occurrences

It counts the number of selected cells and publishes that in A1

Finally it changes the contents of the selected cells and a cell above and to the right of the selected cells.

So.

You should include elements of this in your macro.

I will annotate the macro to help you but it is quite simple really.

Please Login or Register  to view this content.

[Devianey26]

Hi Mehmetcik,

Your solution worked perfectly. Thank you!