Copy sheets

**mmarhala** · 10-20-2008, 07:06 PM

Hi ALL

Help me with this problem !!!

I want to select more than 1 sheet in the workbook but below code only selects first sheet how can I change parameters to either select all or selected sheets...

Please Login or Register  to view this content.

**shg** · 10-20-2008, 07:10 PM

What is Get_Sheet _?

**mmarhala** · 10-20-2008, 07:17 PM

Sorry didnt attach the piece of codehere it is....

=============

' Note: You not have to change the macro below, you only
' edit and run the RDB_Copy_Sheet above.

Please Login or Register  to view this content.

**shg** · 10-20-2008, 07:19 PM

Please read the Forum Rules, and then edit your post to wrap your code with Code Tags.

**mmarhala** · 10-20-2008, 07:28 PM

Sorry for that ..I have made the required changes

**shg** · 10-20-2008, 07:37 PM

The easiest way is probably to replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**mmarhala** · 10-20-2008, 07:51 PM

That is working excel expert !!

but it is giving me seperate workbook for each sheet I want one workbook with all these sheets and I think the second part of the code needs to be modified......what say ....

Please Login or Register  to view this content.

**mmarhala** · 10-20-2008, 08:38 PM

I think I am stuck now -

'How to copy all theses sheets into different worksheets in one workbook" rather than copying them in different workbooks

[U]I want one WorkBook with different sheets [U]...not other way around....