Since Array1 is a one column range its number of elements (rows) would be
equal to Array1.Rows.Count. So I think you can use that as x instead of
passing Array3.

--
Jim Rech
Excel MVP