Like the thread title says. Say I want to write column 3 & 4 to a worksheet range. Is this possible? Or would I need to write column 3 and then column 4?
Like the thread title says. Say I want to write column 3 & 4 to a worksheet range. Is this possible? Or would I need to write column 3 and then column 4?
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
Hello, a thread was put together a while back going over uses for Index and the above is covered in a latter section.
http://www.excelforum.com/tips-and-t...2d-arrays.html
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
It's a Tip thread so post #1 - in basic terms:
use of [ ] purely for shorthand example - not recommended![]()
Please Login or Register to view this content.
I must be missing something.
I am trying to paste columns 1 & 2 of an array to a worksheet range starting from cell A6 to B(length of array data). But when I end up with A6:B12 repeating the same data over and over....
Extract below
![]()
Please Login or Register to view this content.
you missed the Evaluate("ROW(1:" & UBound(av1, 1) & ")") part of the code ;-)
Josie
if at first you don't succeed try doing it the way your wife told you to
As above, the Evaluate element is required to build the Row Array - defaulting row index to 0 (by omission) will not work with this approach.
![]()
Please Login or Register to view this content.
I don't suppose it would be possible to paste FOUR contiguous columns at once? (I tried with the code below but it didn't work. funny that)
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
you resized but not the right size :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks