The range sort has several parameters besides the ones in my example that you can use/change. Try the help file in the VBA editor for more information. For the keys, use the top row as the # and the letter or the column you want to sort. Play around with it for a while and I'm sure you'll get the hang of it.
------------------------------------
Range("A:IV").Sort Key1:=Range("A1"), Key2:=Range("B1"), Key3:=Range("C1")
------------------------------------
Hope this helps point you in the right direction.
|