|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
'共3个条件,条件之间为or关系,单条件按instr判断,全空为false,,,
Option Explicit
Sub test()
Dim arr, mark, i, j, k, m
mark = [h1:m1].Value
arr = Sheets("档案目录").[a1].CurrentRegion.Offset(1).Value
For i = 1 To UBound(arr, 1)-1
For j = 1 To UBound(mark, 2) Step 2
If Len(mark(1, j)) Then
If InStr(arr(i, (j - 1) / 2 + 4), mark(1, j)) Then
m = m + 1
For k = 1 To UBound(arr, 2)
arr(m, k) = arr(i, k)
Next
Exit For
End If
End If
Next
Next
With Sheets("档案查询")
.Range("b:b,k:l").NumberFormatLocal = "yyyy/mm/dd"
With .[a3]
.Resize(Rows.Count - 2, UBound(arr, 2)).ClearContents
If m > 0 Then .Resize(m, UBound(arr, 2)) = arr
End With
End With
End Sub |
评分
-
3
查看全部评分
-
|