|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub ehkjxg()
- Dim d As Object, arr, brr, r, i&, j&, k&, x&, y&
- On Error Resume Next
- Set d = CreateObject("scripting.dictionary")
- arr = [a1].CurrentRegion
- x = 1
- For i = 2 To UBound(arr) + 1
- If arr(i, 1) = "" Then arr(i, 1) = arr(i - 1, 1)
- If Not d.exists(arr(i, 1)) Then
- d(arr(i, 1)) = ""
- If i > 2 Then
- [e1].Offset(x).Resize(i - x - 1, 4).Sort [e:e], xlAscending, Header:=xlNo
- x = i - 1
- End If
- End If
- Next
- Set d = Nothing
- MsgBox "ok"
- End Sub
复制代码 |
|