|
请教如何让根据比较得到的数值输入到单元格后,不再随数据库变化而改变原来输入的内容,因数据库B列内容经常会改变。下面这个代码一旦B列数据变了,原来输入的内容就跟着变了,能不能实现只针对鼠标点击单元格的数值和数据库进行比较把值写入对应列的单元格
Sub test1()
Dim i%, j%, r1%, r2%, arr, brr
With Sheets("sheet1")
r1 = .Cells(.Rows.Count, 1).End(xlUp).Row
arr = .Range("A2:B" & r1)
End With
With Sheets("sheet3")
r2 = .Cells(.Rows.Count, 3).End(xlUp).Row
brr = .Range("C2:F" & r2)
For i = 1 To UBound(brr)
For j = 1 To UBound(arr)
If brr(i, 1) = arr(j, 1) Then
brr(i, 4) = arr(j, 2)
Exit For
End If
Next
Next
.[C2].Resize(UBound(brr), 4) = brr
End With
End Sub
|
|