Public Sub 查找数据()
Dim myRange1 As Range
Dim myRange2 As Range
Dim myRow As Long
Set myRange1 = Columns("C") '指定查询范围
On Error Resume Next
myRow = WorksheetFunction.Match("中国", myRange1, 0) '指定查询条件
On Error GoTo 0
If myRow = 0 Then
MsgBox "没有找到符合条件的单元格"
Else
Set myRange2 = myRange1.Cells(myRow)
MsgBox "符合条件的单元格为:" & myRange2.Address(False, False)
myRange2.EntireRow.Select
End If
Set myRange1 = Nothing
Set myRange2 = Nothing
End Sub