How to make excel copy all but one sheet in a workbook

[Dobbie]

Hello,

I was wondering if someone could help me with a small problem please.

I have set up a macro to copy a section from 31 sheets in a workbook and copy them to a final sheet at the end. This is working ok except that the macro doesn't know that the final sheet shouldn't be included so its also copied.

Is there a way to tell excel not to copy the last sheet?

Here is the macro, I'm new to VBA so apologies if the code is crude, but I've had some wonderful help from the people on here before.

Please Login or Register  to view this content.

[shg]

Maybe like this:

Please Login or Register  to view this content.

[Dobbie]

Thank you for the quick reply, it worked like a charm and is a lot faster too. Many thanks, I'll mark as solved.