| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making array from range
Hello,
I have a range on a worksheet. Cells A1 to A6 contain values. I want to make an array from this with VBA so I can use this array in other VBA code. But I don't know how. Can anyone help me? gr René |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making array from range
Hi René,
Try: Dim arr 'As Variant arr = Range("A1:A6").Value --- Regards, Norman "René" wrote in message ... Hello, I have a range on a worksheet. Cells A1 to A6 contain values. I want to make an array from this with VBA so I can use this array in other VBA code. But I don't know how. Can anyone help me? gr René |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making array from range
Thanks.
gr René "Norman Jones" wrote: Hi René, Try: Dim arr 'As Variant arr = Range("A1:A6").Value --- Regards, Norman "René" wrote in message ... Hello, I have a range on a worksheet. Cells A1 to A6 contain values. I want to make an array from this with VBA so I can use this array in other VBA code. But I don't know how. Can anyone help me? gr René |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making sure a cell in an array is not duplicated | Excel Discussion (Misc queries) | |||
| Making all references in a range absolute | Excel Discussion (Misc queries) | |||
| Making Array Formula, please assist! | Excel Worksheet Functions | |||
| Making progress with array functions, another two questions | Excel Programming | |||
| Making a relative range in VBA | Excel Programming | |||
![René[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
