How do I sort an entire sheet starting with the largest figure and going down accroding to what is in cloumn C, but excluding Row 1?
How do I sort an entire sheet starting with the largest figure and going down accroding to what is in cloumn C, but excluding Row 1?
Select the whole sheet then use excel's built in sort with descending by column C and including a header row.
Maybe:
Sub frank35zzz() Range(Cells(2, 1), Cells(ActiveSheet.UsedRange.Rows.count + 1, ActiveSheet.UsedRange.Columns.count + 1)).Select Selection.Sort Key1:=Range("C2"), Order1:=xlDescending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks