You could drop it onto a spreadsheet and count those

Range("M1:N10") = arry
MsgBox Application.CountIf(Range("M1:N10"), "WB01")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"gti_jobert" wrote
in message ...

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?


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=526695