Hi

you can use COUNTIF worksheet function in code itself

see Chip's site at cpearson.com

hth

Tim

-----Original Message-----
I have a range in a worksheet and need to progmatically
determine the
number of occurences of each piece of data.

Can anyone help me out please. As an example cells A1:A10
might
contain:

A1 Fred
A2 Peter
A3 Peter
A4 Fred
A5 John
A6 Simon
A7 Paul
A8 Mark
A9 Luke
A10 Simon

I need to return:

Fred 2
Peter 2
John 1
Simon 2
Paul 1
Mark 1
Luke 1
.