Dim findcell As Range
Dim fr%
Set findcell = Sheet1.Range("I:I").Find("天津")
Do
If Not findcell Is Nothing Then
fr = findcell.Row
n = n + 1
findcell.EntireRow.Cut Sheet1.Cells(30 + fr + n, 1)
'findcell.EntireRow.Delete '每次剪切行号会变化这样不好,还是全部剪切完了再统一
Else
MsgBox "没查到相关内容"
End If
Loop Until n = 100 '循环100次