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