PDA

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



updown
12-11-2015, 03:58 PM
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
12-12-2015, 06:25 PM
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))