Read in Array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
I know this should be simple, but I want to read in an array (2 rows,
Click to expand...
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify Claus code "Sub Array_Var_Column_Sort()" 27
My Never ending ARRAY code problems 18
Array with many cells from a row but not in order or together 11
VBA Read-Manipulate-Save Text File 5
ERROR 400 on identical codes different range 8
Arrays and scattered cell values or another way? 16
Array code troubles 4
Eliminate blanks while copy row and transpose 11

Back
Top