If workbook is open skip

[namluke]

The below is a macro that opens a workbook, it copies an active sheet, opens a workbook (wb Target) and then pastes to the workbook that was just opened.

I have a few active sheets i would like to copy and paste

As the opened workbook (wb Target) wasnt closed, how would i get it to just copy and paste without reopening to same workbook?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Below is the next step

Please Login or Register  to view this content.

[JBeaucaire]

This is how I would do that:

Please Login or Register  to view this content.

[namluke]

Thank you for this, can i ask what wsSRC stands for?

[JBeaucaire]

I invent my variables at the beginning then use then all through the code. It saves time. This way if I need to change the name of something, in this case then name of the "Source worksheet", I only change it in one place at the top and all the remaining code stays the same.