|
大神,请帮忙更正
Sheet1.Range("A3:D8000").Find(A, LOOKAT:=xlWhole, MatchCase:=False)
这句我要改写在同集目录A.XLS/Sheet1 ,这样的指向该怎么写
完整如下:
Set RE = Sheet1.Range("A3:D8000").Find(A, LOOKAT:=xlWhole, MatchCase:=False)
If RE Is Nothing Then
BINKO = "无"
Else
BINKO = Sheet2.Cells(RE.Row, B).Value
End If
|
|