You've got it backwards...as you yourself noted: Adriano Castro wrote: > UBound(rs_OfficeList_array,1) --> is 0 > UBound(rs_OfficeList_array,2) --> is 7 So therefore rs_OfficeList_array(1, 0) should be out of range. rs_OfficeList_array(0, 1) will have something in it.