Excel 2007 VBA: Store Column in Array Variable

[Ayesdeef]

Hi,

I was wondering how to store a column as an array variable. The column could contain any number of rows.

Apologies, I know this should be simple, but I searched and could not figure it out. I'm still very new to VBA.

 

[solitude]

    Dim x
    x = Sheet1.Range("A1:A10")
    debug.print x(1,1)

OR

    Dim x
    x = Array("a", "b", "c", "d")
    debug.print x(1)

you can add a watch to x, use breakpoint and see the 'structure' of x.

 

[Ayesdeef]

Thank you!