you could just use another array, dimensioned to match the row count and populate that with the values in the loop, then write back to the sheet at the end.