The destination of the data currently is not independent of the array as you
indexing both using the same variable

Try using and extra destination column variable to control the output

For i = 1 To UBound(varArray)
dCol = 5
For j = StartData To EndData
wksDump.Cells(i, dCol) = varArray(i, j)
dCol = sCol + 1
Next j
Next i

--

Regards,
Nigel




"MJKelly" wrote in message
...

Hi, I have the following code which takes data from an array and
dumps it into a worksheet.
Startdata is a column number and enddata is a column number. the
columns of data between these are pasted into the worksheet from the
array. However, I always want the data pasted into column 5 onwards,
but the code is pasting the values into the column numbers of the
array. How do i change this? I've tried adding a count and setting
the start value as 5 (fifth column), but I can't get this to work?

For i = 1 To UBound(varArray)
For j = StartData To EndData
wksDump.Cells(i, j) = varArray(i, j)
Next j
Next i

any help greatly appreciated.

Matt