Read Excel named range to Array

This one is probably easy for you guys
I have a named array of cell in Excel
Ex. cells A1 to A10 are called "Description"
I am trying to read this range into an array in VBA

This way, if one line is added to Description, the code would read the new entry.

Can anyone help ?
thanks

    Dim myArray As Variant
    myArray = Application.Transpose(Range("namedarray"))

Hi,

Why did you use Transpose when

myArray = Application.Range("NamedArray")

seems to work also?

That's the only way I know to reduce from a 2D to 1D vector/array

I tried the Transpose in your code on a 4x2 array and it became a 2x4 array. Still a 2 dimensional array.

I'm not good with getting stuff into arrays so I was excited to see your code and mine below it really put cells into a VBA array. Thanks for the lesson. Now this 2d to 1d confused me.

Hi dizabled and welcome to the forum.

This sounds like a job for Dynamic Named Ranges. If you add a line to your array the DYNAMIC range gets bigger.

See http://www.ozgrid.com/Excel/DynamicRanges.htm or
http://www.exceluser.com/explore/dynname1.htm

Hi dizabled, please use code tags around code as per rule number 3 of the forum rules (located in my signature.