With Tables("表A") Dim r As Integer r = .Find("A", .RowSel + 1, "A列", False, False, True) If r > - 1 Then '如果找到符合条件的行 .Position = r '则选择该行 End If End With