Not sure if this is what you are looking for,If the arrray is referring to Column K, try this:ColumnK = Range("k1").Columns.ColumnFor co = 1 To 17Worksheets(" report"). ActivateCells( 1, d).value = Cells(ColumnK,d).valueNext co