|
像我这种瞎蹦跶的才不是大神,我只是想抛个砖,引来个玉,大神多得很,隐藏在民间,就看你有没有发现神的眼睛
- Sub rg()
- Dim arr, i&, j%, cf, str$, s
- arr = Sheets("jh").[a1].CurrentRegion.Resize(, 2)
- For i = 1 To UBound(arr)
- cf = Split(arr(i, 1), " ")
- For j = 0 To UBound(cf)
- str = str & Replace(Format(cf(j) - 1, "0"), "10", "&")
- Next
-
- With CreateObject("vbscript.regexp")
- .Pattern = "[^" & str & "]"
- .Global = True
- s = .Replace("0123456789&", "")
- For j = 1 To Len(s)
- arr(i, 2) = arr(i, 2) & Format(IIf(Mid(s, j, 1) = "&", 10, Mid(s, j, 1)) + 1, "00") & " "
- Next
- End With
- str = ""
- Next
- Sheets("jh").Columns("c:c").Clear
- Sheets("jh").[c1].Resize(UBound(arr), 1) = Application.Index(arr, , 2)
- End Sub
复制代码
感觉这个办法一点也不好,必须要受数据源的限制,好在你就只有个11,再多这个办法也做不了了
也就是图个拓展思路
|
评分
-
查看全部评分
|