Copy user selected sheets

VBA Noob · Jun 4th 2006

Hi,

I was wondering how you would write a macro to move a selection of sheets to a workbook called Digi's in the D drive.

Also if there isn't a Workbook called Digi's already it needs to add one.

I've found some code to loop through sheets but nothing to show what sheets the user has selected

Thanks in advance

VBA Noob
:confused:

**royUK** · Jun 4th 2006

Re: Copy user selected sheets

I would go with a listbox to select from. Do you want to move the shets or just copy them?

VBA Noob · Jun 4th 2006

Re: Copy user selected sheets

Copy them

**norie** · Jun 4th 2006

Re: Copy user selected sheets

You can copy the user selected sheets to a new workbook like this.

Code

ActiveWindow.SelectedSheets.Copy

Code could be added to this to copy to a specific workbook.

VBA Noob · Jun 4th 2006

Re: Copy user selected sheets

Thanks. That worked a treat

Participate now!