paste_range.count = 262
Please Login or Register to view this content.
ubound(copy_array) = 262
so they should have the same count
but when I perform the paste operation, it pastes the first entry of copy_array into every cell of paste_range
why isn't it pasting each unique value into the worksheet range?
Because you need to transpose the array. Why not simply assign one range to the other though:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
gives me an "Invalid Qualifier" errorPlease Login or Register to view this content.
copy_array is a (1 to 262) Variant array
why and how would I transpose copy_array?
seems to give me gibberish #'sPlease Login or Register to view this content.
Last edited by twd000; 06-09-2010 at 05:19 PM.
I didn't say anything about copy_array.value though?
I can't paste directly from copy_range to paste_range because copy_range is non-contiguous
I fill copy_array with the contents of copy_range and now I'm trying to paste that array into the worksheet
In that case make copy_array a 2D array but have the second dimension only one column. You can then paste to the target range directly.
so copy_array would be listed as Variant(1 to 262, 1 to 1) ?
Well,
to be exact.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks