|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Option Explicit
Sub TEST2()
Dim ar, br, cr, dr, i&, j&, m&, n&, isFlag1 As Boolean, isFlag2 As Boolean
Application.ScreenUpdating = False
ar = [F2:L8].Value
br = [Q2:U8].Value
cr = [AY2:BA8].Value
ReDim dr(1 To UBound(ar), 0)
For i = 1 To UBound(ar)
isFlag1 = False: isFlag2 = False
For j = 1 To UBound(ar, 2)
If Len(ar(i, j)) Then
For m = 1 To UBound(br, 2)
If ar(i, j) = br(i, m) Then isFlag1 = True: Exit For
Next m
End If
Next j
For j = 1 To UBound(ar, 2)
If Len(ar(i, j)) Then
For n = 1 To UBound(cr, 2)
If ar(i, j) = cr(i, n) Then isFlag2 = True: Exit For
Next n
End If
Next j
If isFlag1 * isFlag2 Then dr(i, 0) = 1 Else dr(i, 0) = 0
Next i
[Y2].Resize(UBound(dr)) = dr
Application.ScreenUpdating = True
Beep
End Sub
|
|