|
哦,但你的源代码就是只在“数据一”中查找,if 语句把“数据二”排除了。
- For Each sh In Sheets
- If InStr(sh.Name, "数据一") > 0 Then
- ar = sh.Range("a1").CurrentRegion
- If sh.Name = "数据一" Then
- dz = 48
- hs = 19
- qt = 28
- Else
- dz = 52
- hs = 39
- qt = 70
- End If
- For i = 3 To UBound(ar)
- If Trim(ar(i, dz)) = k Then
- n = n + 1
- br(n, 1) = ar(i, dz)
- br(n, 2) = ar(i, hs)
- br(n, 3) = ar(i, qt)
- End If
- Next i
- End If
- Next sh
复制代码
你试试把“数据一”改名,看程序还能正常运行不? |
|