Problem with outputting only certain columns from array

[jaryszek]

Hi Guys,

i want to output array using application.index but i can not acheve it.

Into G2 i want to output only Col4 and Col5 range.

my code:

Please Login or Register  to view this content.

how to do this?

Best,
Jacek

[mehmetcik]

The simplest solution is to output the whole array and then delete the columns that you are not interested in.

VBA does not allow you to extract a column or a row from an array.

The only other way is to create a second array and use for next loops to copy your data to this second array.

You can then output the second array.

Or you could create the Second arrar directly from your data by only reading the last two columns.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jindon]

For 2d array, if one of the argument of the 2nd & 3rd is array, both needs to be array and 2nd must be 2d, 3rd need to be 1d.

Please Login or Register  to view this content.

[jaryszek]

Thank you!

Jacek