|
在活动单元格不在最后一列的情况下,以下代码会有错误- Sub test()
- Arr = Split(Selection.Address, "$")
- UbdArr = UBound(Arr) - 1
- MsgBox "最后一列的列标是" & Arr(UbdArr)
- End Sub
复制代码 以下代码是通用的
- Sub test()
- Arr = Split(Selection.Address, "$")
- UbdArr = UBound(Arr) + 1
- With Sheets(2).Cells(1, 1).Resize(UbdArr, 1)
- .Value = WorksheetFunction.Transpose(Arr)
- End With
- Sheets(2).AutoFilter.Sort.SortFields.Clear
- Sheets(2).Cells(2, 1).AutoFilter
-
- Sheets(2).AutoFilter.Sort.SortFields.Add _
- Key:=Sheets(2).Cells(2, 1).CurrentRegion, _
- SortOn:=xlSortOnValues, _
- Order:=xlAscending, _
- DataOption:=xlSortNormal
-
- With Sheets(2).AutoFilter.Sort
- .Header = xlYes
- .MatchCase = False
- .Orientation = xlTopToBottom
- .SortMethod = xlPinYin
- .Apply
- End With
-
- MsgBox "最后一列的列标是" & Sheets(2).Cells(65536, 1).End(xlUp).Value
- End Sub
复制代码
[ 本帖最后由 masterexcel 于 2010-8-26 16:23 编辑 ] |
|