Macro to sort data with respect to the column

October 2016


I am facing a problem in sorting the data w.r.t to column header. I have 25 columns in which I need to sort the sata w.r.t to two of the columns. When I tried this with macros I found that the data is sorted along with column header as well and I am struck here without any clue.


You need to start from sort from row 2 and tell that there is a header

Selection.Sort _ 
Key1:=Range("A2"), Order1:=xlAscending, _ 
Header:=xlYes, OrderCustom:=1, _ 
MatchCase:=False, Orientation:=xlTopToBottom, _ 


Thanks to rizvisa1 for this tip on the forum.

Related :

This document entitled « Macro to sort data with respect to the column » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.