Delete Duplicate rows vb needs to run on all worksheets

Hi i have the below code which runs on deleting duplicate code which i found in an excel manual. I am having some trouble as i want to convert the code so that it will run on all worksheets i have which are numbered such as 1,2,3,4 etc.

This is so it makes the workbook easy maintenance for when deleting or adding worksheets which happens quite regularly.

Thanks

Please Login or Register  to view this content.

You need to to edit that original post, highlight all that code, then click the CODE icon (it looks like this: #).

It's a forum rule and makes the code easier to read on the forum.
=========

Meanwhile, you want this macro to run on ALL sheets, or just sheets you've labeled 1,2,3,4...etc.?

For ALL sheets, give this a try, just wrapped your code in another loop for all the worksheets (untested without your workbook).

Please Login or Register  to view this content.

Hello sandy.beach,

Which sheet names do you want to exclude?

Hello sandy.beach,

The macro will loop through all the sheets in the workbook. I used the Select Case statement to exclude the worksheets you posted. Here is the updated macro code.

Please Login or Register  to view this content.