UBound(Arry,1)

and

UBound(Arry,2)

for the two dimensions of the array

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"gti_jobert" wrote
in message ...

Hi all,

I have filled a 2d array with values - can i find out the size of the
array WHERE Arry(1, i) = 'WB01' - for example.

TIA


--
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