Sub aa()
With Sheets("sheet2")
Set A1 = .Rows(1).Find(Range("A1"))
If A1 <> "" Then
Set R = .Columns(A1.Column).Find(Range("A3"))
If R <> "" Then
R.Interior.ColorIndex = 3
End If
End If
End With
End Sub
Sub aa()
With Sheets("sheet2")
Set A1 = .Rows(1).Find(Range("A1"))
If A1 <> "" Then
Set R = .Columns(A1.Column).Find(Range("A3"))
If R <> "" Then
R.Interior.ColorIndex = 3
Else
Msgbox "没找到"& Range("A3")
End If
Else
Msgbox "没找到"& Range("A1")
End If
End With
End Sub
Sub aa()
With Sheets("sheet2")
Set A1 = .Rows(1).Find(Range("A1"))
If Not A1 Is Nothing Then
Set R = .Columns(A1.Column).Find(Range("A3"))
If Not R Is Nothing Then
R.Interior.ColorIndex = 3
End If
End If
End With
End Sub