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é