| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Array Transfer
Thanks a lot mate, it worked
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| t-shit transfer - transfer | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| variant array containing cel adresses convert to actual ranges-array | Excel Programming | |||
| Transfer Range to Array | Excel Programming | |||
Linear Mode
