|
汇总表根据名单工作表的名字使用正则表达式,将A列的姓名提取到B列相应位置。下面是我尝试写的代码:代码运行join函数那里报错,是啥问题啊
Sub 汇总()
Dim ss As Range, 区域 As Range, n
arr = Sheets("名单").Range("a2", Cells(Rows.Count, 1).End(xlUp))
a = Join(arr, "|")
Set reg = CreateObject("vbscript.regexp")
Set 区域 = Range("a2", Cells(Rows.Count, 1).End(xlUp))
For Each ss In 区域
With reg
.Global = True
.Pattern = "a"
Set sj = .Execute(ss)
For i = 0 To sj.Count - 1
n = sj(i) & "、" & Chr(13) & n
Next i
ss.Offset(0, 1) = n
n = ""
End With
Next ss
End Sub
arr = Sheets(2).Range("a2", Sheets(2).Cells(Rows.Count, 1).End(xlUp))
|
|