I have a list of data, that calculates totals based on the current row that you are on

I want to be able to sort this data. Can I sort the data without having to select the data. When I select the data, I loose my current row

Please advise

Thanks

The following illustrates sorting a range without selecting it:

With Range("anyrange")
.Sort Key1:=.Cells(1), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End With

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"New Sort" wrote in message
...
I have a list of data, that calculates totals based on the current row
that you are on.

I want to be able to sort this data. Can I sort the data without having
to select the data. When I select the data, I loose my current row.

Please advise.

Thanks