Vba to open closed tabs in a work book then close them

Hi all
I have a bit of a problem with some code I wrote if the tabs sheets are open then the copy move function works fine What I need is to open then close the tabs sheets as it runs
Hope some one can help me

Please Login or Register  to view this content.

Hi,

You don;t need to select stuff just in order to copy it and paste it somewhere else. In fact .Selectin and .Activate are raely necessary. This means you can work with hidden sheets.

So for instance where you have

Please Login or Register  to view this content.

use instead

Please Login or Register  to view this content.

And another improvment, don't use sheet tab names, they are too easily changed by a user and will cause your code to fail. Use the VBA Sheet Code name instead.