VBA Array Transfer

J

JAY

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
 
A

Alan Beban

JAY said:
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
Click to expand...
What version of Excel are you using?

Alan Beban
 
A

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
 
Top