Macro code error: code is near complete

Hi, I have written a macro code as below, however, there seems to be an error.

I am trying to select all rows in sheet 1 with an X in column E to have their respective columns F, G, H & I to be copied and pasted into sheet 2 starting with cell A1, but sheet 2 should not contain any blank rows.

Can anyone pls help to fine tune the macro?

Many thanks.

Please Login or Register  to view this content.

Forum rules require VBA code to be wrapped in code tags.

Please edit your post to add the tags.

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Why not apply an auto filter to the column and copy all of the visible rows in one go?

Basic code - using autofilter, which is more efficient than looping.

Try it on a back up copy first.

Please Login or Register  to view this content.

Sheet references are to sheet code names. Adjust them as required.