Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pasting data from an array | Excel Programming | |||
Pasting an Excel array | Excel Programming | |||
VBA pasting array into cells | Excel Discussion (Misc queries) | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Pasting an array into a range | Excel Programming |