Auto create worksheets

[CE3416]

Wanted to auto create worksheets using extracted cell values in a particular worksheet to name these newly created worksheets. Any help is much appreciated.

Thanks,
Chris

[Solus Rankin]

Please Login or Register  to view this content.

Where "RangeForName" is the cell you would like to pull the name from.

[jaslake]

Hi Chris

Welcome to the Forum!!

Something like this

Please Login or Register  to view this content.

[CE3416]

Jake,

Thanks so much, really appreciate it. it did work like how i want it but i was getting this error message below, but other than that it works.

Chris

---------------------------
Microsoft Visual Basic for Applications
---------------------------
Run-time error '1004':

Application-defined or object-defined error
---------------------------
OK Help
---------------------------

[CE3416]

This thread is SOLVED!

Thanks.

[jaslake]

Hi Chris...I assume you got your Error Message resolved.

You're welcome...glad I could help....tghanks for the Rep.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
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

[CE3416]

Solus,

Thanks for the help. raelly appreciate it.
Chris