表格智创网's Archiver
首页
›
实战技术
› 提取单元格内容分开VBA
nnsea
发表于 2023-10-25 23:48:41
提取单元格内容分开VBA
Sub 提取内容()
Set regx = CreateObject("vbscript.regexp")
With regx
.Global = True
.Pattern = "\S+"
For Each Rng In
Set mat = .Execute(Rng)
For Each m In mat
y = y + 1
Cells(Rng.Row, y + 2) = m
Next
y = 0
Next
End With
End Sub
页:
[1]
查看完整版本:
提取单元格内容分开VBA