i am trying to do the same thing but Ubound is not working b/c my array is pulled from a filtered sheet in excel and the row numbers are not in order, the last row number is 33800 but the array is from filtered data and only has about 1000 rows. Ubound is returning 33800. Any ideas?

Thanks!