| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort entire range with exception of last row
is there a snipet of vba code that could be used to sort 3 columns of
variable length with the exception of the last row (last row used for totals). The column range is a:k (rows, again, are variable). I am looking to sort in this order: column k descending column j descending column a ascending |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sort entire range with exception of last row
On May 19, 4:17*pm, joemeshuggah
wrote: is there a snipet of vba code that could be used to sort 3 columns of variable length with the exception of the last row (last row used for totals). The column range is a:k (rows, again, are variable). *I am looking to sort in this order: column k descending column j descending column a ascending Give this a shot. This is using column A to determine the last row. Change is needed. Sub try() Dim lRow As Long lRow = Cells(Rows.Count, "A").End(xlUp).Row - 1 Range("A2:K" & lRow).Sort _ Key1:=Range("K2"), Order1:=xlDescending, _ Key2:=Range("J2"), Order2:=xlDescending, _ Key3:=Range("A2"), Order3:=xlAscending End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sort entire range with exception of last row
Excellent....Thank you so much!!!
"JW" wrote: On May 19, 4:17 pm, joemeshuggah wrote: is there a snipet of vba code that could be used to sort 3 columns of variable length with the exception of the last row (last row used for totals). The column range is a:k (rows, again, are variable). I am looking to sort in this order: column k descending column j descending column a ascending Give this a shot. This is using column A to determine the last row. Change is needed. Sub try() Dim lRow As Long lRow = Cells(Rows.Count, "A").End(xlUp).Row - 1 Range("A2:K" & lRow).Sort _ Key1:=Range("K2"), Order1:=xlDescending, _ Key2:=Range("J2"), Order2:=xlDescending, _ Key3:=Range("A2"), Order3:=xlAscending End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort entire spreadsheet by one column sort | Excel Discussion (Misc queries) | |||
| Exception from HRESULT: 0x800A03EC while binding values to a range | Excel Programming | |||
| How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
| Excel.Range.Name gives error an exception | Excel Discussion (Misc queries) | |||
| Excel.Range.Name gives error an exception | Excel Programming | |||
Linear Mode
