View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_141_] John[_141_] is offline
external usenet poster
 
Posts: 14
Default [Q] How to create new worksheets based on an array (via named range)

How could I use a named range to create a series of new worksheets?

Details:
I have a named range (A1:A3) called NewSheetNames. I want to create a
new worksheet for each value in the named range. (3 sheets in this
example).

Example:

NewSheetNames (named range)
A1: Sheet1
A2: AnotherSheet
A3: NewSheet

Click button, and vba creates three new sheets called:
1. Sheet1
2. AnotherSheet
3. NewSheet

Any pointers are greatly appreciated!