Counting number of identical values (or text) in a range
 

Can anyone suggest how I can count the number of identical records/cells in a
range (range is in alfabetical order) in a macro routine. So without using
the Countif function in a sheet. I also would like to know the first and the
last position (Index no.) of the records.

Thanks