|
Sub 删除行()'数组
Dim nRow&, m&, Arr(), Brr()
With Sheet1
nRow = .Range("a65536").End(xlUp).Row
Arr = .Range("a2:g" & nRow).Value
ReDim Brr(1 To nRow, 1 To 7)
For i = 1 To nRow - 1
If Arr(i, 7) Like "zuoxi*" Or Arr(i, 7) Like "dudao*" Then
m = m + 1
For j = 1 To 7
Brr(m, j) = Arr(i, j)
Next
End If
Next
.Range("a2:g" & nRow).Value = Brr
End With
End Sub
麻烦改一下,把固定的“ "zuoxi*" ”和 “ "dudao*"”条件,改成动态的,假设我把条件放在Sheet2,A列的A2:A51区域内,应该怎么改??
If Arr(i, 7) Like "zuoxi*" Or Arr(i, 7) Like "dudao*" Then
|
|