Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The code below is run by clicking on a UserForm button which is part of
WorkBook Vacation.xls. Is there any way to perform this with out making Employee List.xls active or to return me to where I was in Vacation.xls after the sort is complete? Sub PT_Driver_Last_Name_Sort() ' ' Macro1 Macro ' Macro recorded 12/20/2005 by Cathy Baker ' 'Sort by Paratransit Drivers Last Name Windows("Employee List.xls").Activate Worksheets("Employee_List").Range("AA1").Value = 2 Dim wks As Worksheet Set wks = Worksheets("Employee_List") With wks.Range("A1:Z300") ..Sort Key1:=wks.Range("E2"), Order1:=xlAscending, Key2:=wks.Range("F2") _ , Order2:=xlAscending, Key3:=wks.Range("A2"), Order3:=xlAscending, Header:= _ xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _ xlSortNormal End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calling macros in another workbook | Excel Worksheet Functions | |||
Trouble with Calling a workbook | Excel Programming | |||
Calling another workbook not working | Excel Worksheet Functions | |||
Reference code in another workbook from a calling workbook | Excel Programming | |||
calling sub from another workbook | Excel Programming |