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

JAY wrote:

I am using the excel 97
Thanks

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

JAY wrote:

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