If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

ArrayCountIf(Arry,"WB01") will return the number of occurrences.

Alan Beban

gti_jobert wrote:
yes i am,

suppose I would just loop through the entire array and set up a count
where array = 'WB01' - thought I might just be able to use ubound with
a criteria set on it?