Sort method possible without using select
 

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.

Sort method possible without using select
 

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.

Sort method possible without using select
 

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.