|
麻烦各位看看,哪里出错了!!!!!!
本帖最后由 chart888 于 2017-6-17 17:09 编辑
- Private Sub CommandButton1_Click()
- Dim arr, brr, i&, k&
- arr = Worksheets("数据库").Range("D2:H" & Worksheets("数据库").Cells(Rows.Count, 4).End(3).Row) '
- brr = Worksheets("数据查询").Range("AL6:AP6")
- For i = 1 To UBound(arr)
- For k = 1 To 5
- If brr(1, k) <> "" Then
- If brr(1, k) = arr(i, k) Then
- Worksheets("数据库").Cells(i + 1, 19) = "真的"
- Else
- Worksheets("数据库").Cells(i + 1, 19) = ""
- GoTo AA
- End If
- End If
- Next
- AA:
- Next
- End Sub
复制代码
|
|