|
发表于 2016-4-13 23:37
|
显示全部楼层
本楼为最佳答案
Option Explicit
Dim B(1 To 10000, 1 To 1), s
Sub test()
Dim A, i
s = 0
A = Range("a1").CurrentRegion
For i = 1 To UBound(A)
Call reg(A(i, 1))
Next
[e:e] = ""
[e1].Resize(s) = B
End Sub
Sub reg(str)
Dim matchs As Object, match As Object
With CreateObject("VBScript.RegExp")
.Global = True
.Pattern = "\d{6}"
Set matchs = .Execute(str)
For Each match In matchs
s = s + 1
B(s, 1) = match
Next
End With
End Sub
888b.rar
(19.88 KB, 下载次数: 9)
|
评分
-
查看全部评分
|