Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I sort on the column selected by the user?
I query the user via a userform to select the heading (column) they want to
sort on. The userform returns a column. I need to sort everything from row 11 down based on the column selected. I have no problem selecting the cells from A11 to the end, but I don't know the code to perform the sort. Will somebody please help? this is my code for the selecting the range that needs to be sorted x = Range("A" & Rows.Count).End(xlUp).Row Range("A11", "AA" & x).Select If the user selects "ORDER NUMBER" from the user form (column y), how do I sort my range on column y? -JEFF- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I sort on the column selected by the user?
This is a simple example that may help you.
Sub a() Dim Key As String Dim SortCell As Range Key = "HeaderX" Set SortCell = Range("A1:E1").Find(Key) Range("A1:E8").Sort Key1:=SortCell, Header:=xlYes End Sub Here I have a small database in the range A1 to E8. Row 1 has the column/field headers and I know that the field I want to sort by is headed by "HeaderX". First I find the cell containing HeaderX and set the range variable SortCell to it. Then I use that to set the first sort key in doing the sort. -- Jim "-JEFF-" wrote in message ... |I query the user via a userform to select the heading (column) they want to | sort on. The userform returns a column. I need to sort everything from row | 11 down based on the column selected. I have no problem selecting the cells | from A11 to the end, but I don't know the code to perform the sort. Will | somebody please help? | | this is my code for the selecting the range that needs to be sorted | x = Range("A" & Rows.Count).End(xlUp).Row | Range("A11", "AA" & x).Select | | If the user selects "ORDER NUMBER" from the user form (column y), how do I | sort my range on column y? | -JEFF- | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sort a column of Randomly selected numbers? | Excel Worksheet Functions | |||
How to sort on the row selected by user? | Excel Programming | |||
Opening a user selected workbook | Excel Programming | |||
Get user selected range into RefEdit | Excel Programming | |||
How to find out what the user selected? | Excel Programming |