The first time I'm here...

My question is about the sort function in VBA Excel.
I want my address-database yellow-white striped, but when I use a
standard sort function, the layout is sorted too.
That's why I'm looking for an extra option to escape the layout for
sorting.

Code:
--------------------
Rows("3:22").Sort Key1:=Range(first), Order1:=ord, Header:=xlNo, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom

--------------------

I hope there's somebody who can help my find this option!

Joey11 (Newbie)


---
Message posted from http://www.ExcelForum.com/