UBound provides the current upper bound of the specified dimension of the
array.

I suspect there is nothing faster than looping through the array. Set it up
as a function that accepts the array and the target string as arguments and
you will have a reusable routine.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

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