Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read in Array
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.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to read offset cells from dynamic sort array formula? | Excel Discussion (Misc queries) | |||
How to Read Worksheet Data into VBA Array? | Excel Discussion (Misc queries) | |||
using VB to read in a column of values of varying length into an array | Excel Worksheet Functions | |||
Excel, read in an array | Setting up and Configuration of Excel | |||
Read Range Data into Array | Excel Programming |