Posted to microsoft.public.excel.programming

external usenet poster

Posts: 74

Sort Method question

Good Day Group,

Below code works fine as long Sheet(3) is active. How to
write the code to work also when another WorkSheet is
the active sheet.? Is that possible?

Brgds

CG Rosén

Sheets(3).Columns("O:U").Sort Key1:=Range("O1"), Order1:=xlAscending,
Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortTextAsNumbers

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
VBA Sort method w/more than 3 Keys	KenRoy	Excel Discussion (Misc queries)	1	August 26th 05 10:48 PM
Sort Method	Squid[_3_]	Excel Programming	3	March 2nd 04 02:25 PM
Sort Method Questions	pikus	Excel Programming	2	February 3rd 04 03:46 PM
sort method frustration	David Wenham	Excel Programming	2	August 21st 03 06:26 PM
Sort method of range	Richard Clarke	Excel Programming	7	July 25th 03 04:42 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us