I'm trying to sort by color
Can anyone assist me, I'm trying to sort two columns in ascending order. The first column by color and the second by data. My code is below
Range("A2").Select
Selection.Sort Key1:=Range ("E2"), _xlSortOnCellColor, xlAscending, , xlSortNormal).SortOnValue.Color = RGB(255, _ 199, 206),
Order1:=xlAscending, Key2:=Range("F2") _ , Order2:=xlAscending, MatchCase:=False, Orientation:=xlTopToBottom
Last edited by Nita; August 26th, 2013 at 08:16 PM..
Reason: Posted in wrong Forum
|