ExcelBanter - Read in Array

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Read in Array (https://www.excelbanter.com/excel-programming/297272-read-array.html)

I know this should be simple, but I want to read in an array (2 rows, about 10 columns). The 1st row is G1: K1 and the second is G90:K90. I want to sort by row 2 and output the top 5 values in a column (so, transposed). I've got the sort down, but I'm unsure of how to read in the two rows.

Leigh,

Do you mean

myArray = Worksheets("Sheet1").Range("G1:P2")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Leigh" wrote in message
...
I know this should be simple, but I want to read in an array (2 rows,
about 10 columns). The 1st row is G1: K1 and the second is G90:K90. I
want to sort by row 2 and output the top 5 values in a column (so,
transposed). I've got the sort down, but I'm unsure of how to read in the
two rows.