I have a list of names
Name:
x
y
z
x
a
b
c
d
x
x
a
b
c

I want to way to quickly count the number of occurances of each name using vba. Anyone know a quick way to do this?

I know a pivot table would be easy but this will be part of a vba macro so a pivot table wont work for me.