Paste array to range

[Bob@Sun]

Hello,

I have a dynamic array which I need to paste in excel

Please Login or Register  to view this content.

How can I do that?

Thanks,
BK

[DonkeyOte]

You can use UBound (& LBound where nec.)

Please Login or Register  to view this content.

If you know you will always use Base 1 then:

Please Login or Register  to view this content.

[Bob@Sun]

The problem is that using Ubound gives me always 7 as the array is defined like this:

a(1 to 7 , 1 to i)

[DonkeyOte]

Not if you specify the dimension it doesn't (it defaults to dimension 1 if unspecified)

Did you test the example ?

[Bob@Sun]

I tested it but could not make it to work.

Attached is a sample file. You can see the array how it is assigned, could you please paste it as I have shown in the excel?

Thanks
BK

[DonkeyOte]

If you're trying to return the 7x2 array to 2x7 range then you will need to transpose the Array and invert the Ubounds, eg:

Please Login or Register  to view this content.

I am presuming this is a hypothetical scenario given the way the Array is being populated...

(and again, the above is assuming Option Base 1 at all times re: a)

[snb]

Please Login or Register  to view this content.

[Bob@Sun]

Thanks a lot, this is working as expected now.

One question though, what means that the code is assuming Option Base 1 at all times?

Thanks again

BK

[DonkeyOte]

see VBE Help re: Option Base