LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 343
Default Sort question (of sorts)

The code below runs a sort on the Relief Board worksheet (the worksheet is
not active) the problem is that when you do go to that worksheet the range
A6:J3000 is still selected. Is there any way to clear the selection and have
the cell C6 be active?


ActiveWorkbook.Worksheets("Relief Board").Sort.SortFields.Add
Key:=Range( _
"A7:A3000"), SortOn:=xlSortOnValues, Order:=xlAscending,
DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Relief Board").Sort
.SetRange Range("A6:J3000")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
how to make rows 'sort with' between sheets during separate sorts Margo Excel Worksheet Functions 4 November 9th 07 08:34 PM
How to I sort in 2 worsheets where an unlinked column sorts as wel CrazyGnome1966 Excel Discussion (Misc queries) 1 August 8th 06 08:03 PM
When I try to sort in Excel only part of the table sorts jrw562 Excel Discussion (Misc queries) 6 March 5th 06 08:31 PM
sort in excel that sorts digikey Albert Mulder Excel Worksheet Functions 1 March 1st 06 07:59 PM
How to exclude header row from sort button sorts? JCabo Excel Discussion (Misc queries) 1 March 25th 05 11:25 PM


All times are GMT +1. The time now is 06:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"