Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Anyone -
Can you tell me the code an Addin would use to sort cells on a worksheet in the Addin? I've tried this, but it does not always work: Workbooks("MyAddInName.xla").Activate Sheets("Sheet1").Activate Columns("A:C").Select Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Key2:=Range("B1") _ , Order2:=xlAscending, Key3:=Range("C1"), Order3:=xlAscending, Header:= _ xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Thank you for any assistance. MSweetG222 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I edit a worksheet that has been defined as an addin | Excel Discussion (Misc queries) | |||
Worksheet visible in an addin ? | Excel Programming | |||
Access to Worksheet in AddIn.xla | Excel Programming | |||
Using UDF in COM Addin as formula in worksheet | Excel Programming | |||
raw speed for excel worksheet functions? - xll -or com addin? | Excel Programming |