Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
My sort isn't working ...
The line in red is giving me a sort method of Range class failed".
Two things to note that may be problematic, and they in themselves are problems I don't know how to overcome if they are contributors to the error.
PL = 12, and there are no values in column F (but then again there are none in column R either and it passes that sort)
Rich (BB code):
With .Range("A13:R" & pl)
.Sort key1:=.Range("R13"), order1:=xlAscending, Header:=xlNo, _
OrderCustom:=Application.CustomListCount + 1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
.Sort key2:=.Range("F13"), order2:=xlAscending, Header:=xlNo, _
OrderCustom:=Application.CustomListCount + 1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption2:=xlSortNormal
End With
The line in red is giving me a sort method of Range class failed".
Two things to note that may be problematic, and they in themselves are problems I don't know how to overcome if they are contributors to the error.
PL = 12, and there are no values in column F (but then again there are none in column R either and it passes that sort)