R RB Smissaert Jun 19, 2006 #2 Lookup UBound in the VBA help. Dim Arr(1 to 100) as String MsgBox UBound(Arr) This will give 100 RBS
B Bob Phillips Jun 19, 2006 #3 Use UBound(Arr) - LBound(Arr) + 1 in case it doesn't start at 1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
Use UBound(Arr) - LBound(Arr) + 1 in case it doesn't start at 1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
G Guest Jun 19, 2006 #4 a more general determination for a single dimension: Dimensionsize = Ubound(a) - lbound(a) + 1
