VBA Array Transfer

[Guest]

Hi Everyone

I am developing code which requires to transfer a range of cell values into a VBA Array. if there is any limitation on doing this

Thanks

 

[Alan Beban]

Hi Everyone,

I am developing code which requires to transfer a range of cell values into a VBA Array. if there is any limitation on doing this.

Thanks

What version of Excel are you using?

Alan Beban

 

[Guest]

I am using the excel 97
Thank

----- Alan Beban wrote: ----

JAY wrote

Hi Everyone

What version of Excel are you using

Alan Beba

 

[Alan Beban]

Dim arr As Variant
arr = Sheets("whatever").Range("whateverelse")

will work for up to 5461 values. If you might need more, or if your
array can not be held in a Variant variable, post back.

Alan Beban

 

[Guest]

Thanks a lot mate, it worked