|
我是一个初学者,在尝试给Pattern加入一个变量或者一个数组,用工作表的某列来建立数组,这种方法是否可行?
请高手看看我写的下列代码错误在哪里?该怎样写才正确,请指正,非常感谢!
Option Explicit
Sub s_filter()
Dim dat As Worksheet, res As Worksheet, AR As Worksheet
Dim ln As Long, i As Long, k As Integer
Dim arr()
Set dat = Sheets("未确认收入") '要筛选的原始表
Set res = Sheets("本期确认收入") '符合条件结果保存表
Set AR = Sheets("AR模块OEM")
Dim n As Long
Dim j As Long
With Sheets("AR模块OEM").Activate
n = Application.WorksheetFunction.CountA(AR.Range("J:J"))
ReDim arr(1 To n) As String
For j = 1 To n
arr(j) = Cells(j, 9)
ln = dat.[a60000].End(3).Row '提示对象变量或with块变量未设置
With CreateObject("vbscript.regexp")
.Global = False
.Pattern = arr(j) '正则样式是否可行?
.Global = True
.MultiLine = False
For i = 1 To ln
If .test(dat.Range("J" & i).Value) Then '提示对象变量或with块变量未设置
k = k + 1
dat.Range("A" & i).EntireRow.Copy res.Range("A" & k + 1)
End If
Next i
MsgBox k
End With
Set res = Nothing
Set dat = Nothing
Next j
End With
End Sub
|
|