Macro to Create Worksheet 'xxxx' and list All Worksheets in Workbook

**R_S_6** · 02-02-2009, 06:23 AM

Hi All,

I am after some code to create a new worksheet called 'xxxx' in my workbook, and then list all the sheets within the workbook (excluding the newly created 'xxxx' sheet.)

Hope someone can help.

Cheers

**DonkeyOte** · 02-02-2009, 06:35 AM

One way:

Please Login or Register  to view this content.

**R_S_6** · 02-02-2009, 06:52 AM

That's Great -Worked 1st Time! Much Appreciated

Cheers

**VBA Noob** · 02-02-2009, 08:56 AM

Next time If you're satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save