Repeat Macro for multiple Sheets - Next without For

[MelForsyth]

I have multiple sheets with the same layout some have different data. My code goes to each sheet and filters on criteria then copies to another sheet. However, if there is no data it copy it gets stuck.
I tried putting in an If IsEmpty line so the loop would move to the next sheet but I keep getting a compile error: Next without For.

I have been searching for hours but am getting no closer to a fix. Here is my code:

Please Login or Register  to view this content.

[AB33]

Please use code tags with your code as per forum's rule.

Please Login or Register  to view this content.

Is looping through a range in sheet 3, as sheet_name is a range, not a sheet

You need

Please Login or Register  to view this content.

[MelForsyth]

Thank you for your advise and sorry for my error.

I have changed the code as you suggested but I am still getting the error. I have added a line to my code below to show where the error is triggered. I have tried changing the order but get the same compile error.

Please Login or Register  to view this content.

[AB33]

It appears to me there are few errors on the code and still more errors to be found.

Please Login or Register  to view this content.

This should give you some idea on how to loop through sheet collection

Please Login or Register  to view this content.