Read in Array
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.
|