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

Hi there,

How is this related to my book about ASP.NET? I think you need to find the appropriate category (whatever the technology you're using is) from the Category list and post there.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!