|
希望可以把自定义的名字换成按单元格的内容排序,曾试过把名字换成CustomOrder:= _ "e2,e3,e4,e5,e6,e7,e8,e9,e10,e11,e12,e13,e14,e15,e16",没有用。希望大神帮忙!!!!!!!!!
Sub Macro11()
'
' Macro11 Macro
'
' 快捷键: Ctrl+y
'
Range("C2:F19").Select
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("C2:C19") _
, SortOn:=xlSortOnValues, Order:=xlAscending, CustomOrder:= _
"谢太阳,朱水平,蔡志群,陈长海,陈长钱,陈长任,陈春香,陈丹,陈东方,陈冬娇,陈冬仔,陈光辉,陈红英,陈菊连,陈黎文", DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Sheet1").Sort
.SetRange Range("C2:F19")
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub
本帖最后由 大灰狼1976 于 2014-6-2 18:54 编辑
试试这样行不行,没附件不能测试,错了不要怪我啊。
另,好象跟我录制的宏一点都不一样啊,你是哪个版本的?我2003 - Sub Macro11()
- '
- ' Macro11 Macro
- '
- ' 快捷键: Ctrl+y
- dim arr
- arr = Application.Transpose([e2:e16])
- Range("C2:F19").Select
- ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
- ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("C2:C19") _
- , SortOn:=xlSortOnValues, Order:=xlAscending, CustomOrder:= _
- Join(arr, ","), DataOption:= _
- xlSortNormal
- With ActiveWorkbook.Worksheets("Sheet1").Sort
- .SetRange Range("C2:F19")
- .Header = xlGuess
- .MatchCase = False
- .Orientation = xlTopToBottom
- .SortMethod = xlPinYin
- .Apply
- End With
- End Sub
复制代码
|
|