|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
居然不能上传附件,论坛又出问题了
先发个代码吧。
- Sub ykcbf() '//2024.3.18
- Set reg = CreateObject("VBScript.Regexp")
- r = Me.Cells(Rows.Count, 1).End(3).Row
- arr = Me.[a1].Resize(r, 7)
- ReDim brr(1 To UBound(arr), 1 To 6)
- With reg
- .Global = True
- .Pattern = "(\d+)"
- For i = 3 To UBound(arr)
- s = arr(i, 4)
- If .test(s) Then
- m = m + 1
- For j = 2 To UBound(arr, 2)
- brr(m, j - 1) = arr(i, j)
- Next
- End If
- Next
- Me.[k4:p10000] = ""
- Me.[k4].Resize(m, 6) = brr
- End With
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
2
查看全部评分
-
|