Is it possible to use Application.Index to write 2 adjoining columns in one go?

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?

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

Originally Posted by DonkeyOte

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

Thank you. I skimmed through the thread but couldn't find what I was looking for. Which post # was it?

It's a Tip thread so post #1 - in basic terms:

Please Login or Register  to view this content.

use of [ ] purely for shorthand example - not recommended

Originally Posted by DonkeyOte

It's a Tip thread so post #1 - in basic terms:

Please Login or Register  to view this content.

use of [ ] purely for shorthand example - not recommended

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 ;-)

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.

Originally Posted by DonkeyOte

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.

It worked! Thank you! Thank you!

Originally Posted by JosephP

you missed the Evaluate("ROW(1:" & UBound(av1, 1) & ")") part of the code ;-)

Well, not overlooked exactly. In my ignorance, I thought it wouldn't be necessary...

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.

Originally Posted by JosephP

Please Login or Register  to view this content.

Slaps head. Hard.

Of course. I forgot to resize.

Thanks for that JosephP

you resized but not the right size :-)