| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting a portion of an array
Hello
i would like to paste an array to my spreadsheet but i only want to paste the right most column to the sheet. i simply cannot rememeber how to resize it. I think i have the left side of the equation correct but.... wbk.Application.Range("drop_here").Resize(UBound(v Template, 1), 1).Value = vTemp Thank you in advance. W |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting a portion of an array
ww wrote:
Hello i would like to paste an array to my spreadsheet but i only want to paste the right most column to the sheet. i simply cannot rememeber how to resize it. I think i have the left side of the equation correct but.... wbk.Application.Range("drop_here").Resize(UBound(v Template, 1), 1).Value = vTemp Thank you in advance. W If vTemp has fewer elements than 5461 or you're working in a version of Excel later than xl2000, change vTemp to Application.Index(vTemp,0,1). Alan Beban |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting a portion of an array
Alan Beban wrote:
ww wrote: Hello i would like to paste an array to my spreadsheet but i only want to paste the right most column to the sheet. i simply cannot rememeber how to resize it. I think i have the left side of the equation correct but.... wbk.Application.Range("drop_here").Resize(UBound(v Template, 1), 1).Value = vTemp Thank you in advance. W If vTemp has fewer elements than 5461 or you're working in a version of Excel later than xl2000, change vTemp to Application.Index(vTemp,0,1). Alan Beban Whoops! I gave you code for the leftmost column. For the rightmost substitute Application.Index(vTemp, 0, UBound(vTemp, 2) - LBound(vTemp, 2) + 1) Sorry, Alan Beban |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA pasting array into cells | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
| Sorting 2D portion of 5D Array | Excel Programming | |||
| Is there a way to get a portion of a WEB | Excel Programming | |||
Linear Mode
