|
风林火山 发表于 2014-1-20 19:04
Sub test()
Dim arr, brr, k%, i%, n%
arr = Range("a1:c" & Cells(Rows.Count, 1).End(3).Row)
...
借用风林的代码优化一下- Sub test()
- Dim arr, k%, i%
- arr = Range("a1:c" & Cells(Rows.Count, 1).End(3).Row)
- With CreateObject("vbscript.regexp")
- .Global = True
- .Pattern = "([B-Z]+\d.+? ).+?(\d.+)"
- For k = 2 To UBound(arr)
- For Each m In .Execute(arr(k, 1))
- arr(k, 2) = .Replace(m.Value, "$1")
- arr(k, 3) = .Replace(m.Value, "$2")
- Next m
- Next k
- End With
- arr(1, 2) = "货号": arr(1, 3) = "尺码"
- Sheet2.Cells.ClearContents
- Sheet2.Range("a1").Resize(UBound(arr), UBound(arr, 2)) = arr
- Sheet2.Select
- End Sub
复制代码 |
|