Sleeper: Creating a one-dimensional array from a list on Excel.

[updown]

Hi everyone,

I am trying to create two one-dimensional arrays that return the values in two columns given a specific criteria. I am a bit lost with this problem. Thanks in advance!

[mikerickson]

Does this help?
If not, what is losing you?

Dim myOneDimensionalArray as Variant

myOneDimensionalArray = Application.Transpose(Range("A1:A10").Value)

' or

myOneDimensionalArray = Application.Transpose(Application.Transpose(Range("A1:Z1").Value))