This is what i have:

Sheets("Data1").Select
Range("DailyMeasures").Sort Key1:=Range("A4"), Order1:=xlAscending
(where DailyMeasures is a named range in the worksheet Data1)

Is it possible to carry out this sort method without having to actually
Select the sheet.

Any help appreciated
Jason.

Good Morning Jason,
I believe this is what you are looking for. You don't have select sheet
or range to do the sort. Have a great day..

Rick, (Fairbanks, AK {Land of the Midnight Sun})

============================

Dim ws as worksheet
Dim DmRng as Range

set ws = worksheets("Data1")
set DmRng = ws.Range("DailyMeasures")

DmRng.Sort Key1:=Range("A4"), Order1:=xlAscending ......

============================

"WhytheQ" wrote in message
oups.com...
This is what i have:

Sheets("Data1").Select
Range("DailyMeasures").Sort Key1:=Range("A4"), Order1:=xlAscending
(where DailyMeasures is a named range in the worksheet Data1)

Is it possible to carry out this sort method without having to actually
Select the sheet.

Any help appreciated
Jason.

Or for less coding you can just do

range("").sort Key1:=Range("A4"), Order1:=xlAscending

"Rick Hansen" wrote:

Good Morning Jason,
I believe this is what you are looking for. You don't have select sheet
or range to do the sort. Have a great day..

Rick, (Fairbanks, AK {Land of the Midnight Sun})

============================

Dim ws as worksheet
Dim DmRng as Range

set ws = worksheets("Data1")
set DmRng = ws.Range("DailyMeasures")

DmRng.Sort Key1:=Range("A4"), Order1:=xlAscending ......

============================

"WhytheQ" wrote in message
oups.com...
This is what i have:

Sheets("Data1").Select
Range("DailyMeasures").Sort Key1:=Range("A4"), Order1:=xlAscending
(where DailyMeasures is a named range in the worksheet Data1)

Is it possible to carry out this sort method without having to actually
Select the sheet.

Any help appreciated
Jason.