LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 114
Default help pasting data from an array


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting data from an array LauraC Excel Programming 1 March 31st 06 01:37 PM
Pasting an Excel array ram Excel Programming 11 December 23rd 05 02:21 PM
VBA pasting array into cells Jeff Excel Discussion (Misc queries) 1 December 6th 05 01:58 AM
Pasting on Filtered Data Sheets without pasting onto hidden cells CCSMCA Excel Discussion (Misc queries) 1 August 28th 05 01:22 PM
Pasting an array into a range Tony Excel Programming 4 January 7th 05 12:24 AM


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"