改自帮助中的示例代码
Sub test()
Sheets("自建").Select
Cells.Clear
With Sheets("sheet1").[a:a]
Set c = .Find("今天", LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
i = i% + 1
c.Resize(1, 2).Copy Cells(i, 1)
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
End Sub