I have my folders auto sorting on certain column like this:
Sub Worksheet_Activate()
rowcount = ActiveSheet.UsedRange.Rows.Count
Range(Cells(9, 1), Cells(rowcount, 13)).Select
Selection.Sort Key1:=Range("F9"), Order1:=xlAscending, _
Header:=xlNo, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
Range("A1").Activate
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
End Sub
IS THERE A WAY TO SKIP A ROW in THE 13 Could?
Currently I am SORTING 13 Rows which is:
A-B-C-D-E-F-G-H-I-J-K-L-M
I would like to SKIP Rows G & H
Which are Rows 7 & 8
Let me know - Thanks - Take Care - Chris
Sub Worksheet_Activate()
rowcount = ActiveSheet.UsedRange.Rows.Count
Range(Cells(9, 1), Cells(rowcount, 13)).Select
Selection.Sort Key1:=Range("F9"), Order1:=xlAscending, _
Header:=xlNo, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
Range("A1").Activate
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
End Sub
IS THERE A WAY TO SKIP A ROW in THE 13 Could?
Currently I am SORTING 13 Rows which is:
A-B-C-D-E-F-G-H-I-J-K-L-M
I would like to SKIP Rows G & H
Which are Rows 7 & 8
Let me know - Thanks - Take Care - Chris