Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Is there a way to have a macro written to include many sort keys? The
one I have now sorts for 3 things - but it seems when I try to sort for 4, it gives me an error? This is what I currently have: Sub SortMe() Cells.Sort Key1:=Range("F1"), Key2:=Range("B1"), Key3:=Range("C1"), Header:=xlYes End Sub I tried just adding in to make it: Sub SortMe() Cells.Sort Key1:=Range("F1"), Key2:=Range("B1"), Key3:=Range("C1"), Key4:=Range("D1"), Header:=xlYes End Sub But it says "Named Argument Not Found"... am I doing something wrong? Can someone help?? (I didn't write the macro - someone else just told me what to put and where it went!) Thanks :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
F- Keys | Excel Worksheet Functions | |||
Hot Keys | Excel Worksheet Functions | |||
VBA Sort method w/more than 3 Keys | Excel Discussion (Misc queries) | |||
use of F3 & F9 keys | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) |