質問番号:1416654240
Option Explicit Sub main() Dim LastRow As Long Dim CopyRow As Long Dim lp As Long Worksheets(2).Cells.Clear LastRow = Me.Range("E" & Rows.Count).End(xlUp).Row CopyRow = 1 For lp = 3 To LastRow If InStr(Range("E" & lp), "あいうえお") > 0 Then Me.Range(lp - 2 & ":" & lp).Copy Worksheets(2).Range(CopyRow & ":" & CopyRow + 2).PasteSpecial CopyRow = CopyRow + 3 End If Next lp End Sub