Excel - VBA - Array and sheet *Resolved*

[Ecniv]

Hi,

I know that you can put an array into a range and it posts in it beautifully. And Quickly.

Now how do you do the opposite ad get a range into an array of variant??

I tried the opposite :

Redim aryTitles(21)
aryTitles() = shtSrc.Range(shtSrc.Cells(1, 1), shtSrc.Cells(1, 21))

This doesn't work and the array is reset to 0 elements.

Any ideas?


Vince