Posted to microsoft.public.excel.programming

WhytheQ

external usenet poster

Posts: 246

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
select method	R..VENKATARAMAN	Excel Programming	4	February 28th 06 12:31 PM
Select Method from Combo Box	bw	Excel Programming	6	August 25th 05 11:47 PM
Select Method Failing	cmk18[_8_]	Excel Programming	2	July 11th 05 11:53 PM
Select Method of Sheets	Brenda Meza via OfficeKB.com	Excel Programming	2	May 20th 05 12:37 AM
Help with Select Case or Best Method	Christina[_4_]	Excel Programming	1	November 5th 03 06:15 PM

All times are GMT +1. The time now is 06:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us