Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to make rows 'sort with' between sheets during separate sorts | Excel Worksheet Functions | |||
How to I sort in 2 worsheets where an unlinked column sorts as wel | Excel Discussion (Misc queries) | |||
When I try to sort in Excel only part of the table sorts | Excel Discussion (Misc queries) | |||
sort in excel that sorts digikey | Excel Worksheet Functions | |||
How to exclude header row from sort button sorts? | Excel Discussion (Misc queries) |