ExcelBanter - VBA Array Transfer

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA Array Transfer (https://www.excelbanter.com/excel-programming/300365-vba-array-transfer.html)

JAY

VBA Array Transfer

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[_2_]

VBA Array Transfer

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

JAY

VBA Array Transfer

I am using the excel 97
Thank

----- 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 Beba

Alan Beban[_2_]

VBA Array Transfer

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

JAY

VBA Array Transfer

Thanks a lot mate, it worked

All times are GMT +1. The time now is 04:38 AM.