Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
I have a program that outputs columns of values to a worksheet. I have titles in row 2 and the values start in columns "E3:G?", "I3:L?" etc. I would like to sort the values but I don't know what the last row will be. Here is an example for columns "E3:G?" ... Range("E3:G?").Select Selection.Sort Key1:=Range("G3"), Order1:=xlDescending, Key2:=Range("E3") _ , Order2:=xlAscending, Key3:=Range("F3"), Order3:=xlAscending .... with the ? is the unknown number to sort down to. Thanks in Advance. All the Best. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Knowing the number | Excel Discussion (Misc queries) | |||
Identifying value in a cell knowing R1C1 naming | Excel Programming | |||
Knowing when Solver closes | Excel Programming | |||
getting a y-value from a graph knowing the corresponding x-value | Excel Discussion (Misc queries) | |||
Select from first worksheet without knowing it's name | Excel Programming |