|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 duquancai 于 2018-6-24 20:03 编辑
看了很久,终于看懂啥意思!请测试:- Sub main()
- Dim a, b, c(), s1$, s2$, js As Object
- r = Cells(Rows.Count, "e").End(3).Row
- a = Range("e3:e" & r): b = Range("o3:o" & r)
- ReDim c(1 To r - 2, 1 To 1)
- Set js = CreateObject("MSScriptControl.ScriptControl")
- js.Language = "JavaScript"
- For i = 1 To r - 2
- If Len(a(i, 1)) * Len(b(i, 1)) Then
- s1 = "[" & a(i, 1) & "]": s2 = "[" & b(i, 1) & "]"
- c(i, 1) = js.eval("a=" & s1 & ";b=" & s2 & ";a.sort(function(x,y){return b[y-1]-b[x-1]});")
- End If
- Next
- Range("b3:b" & r) = c
- MsgBox "OK!"
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|