Results 1 to 6 of 6

A VBA code to add worksheets with the names given as a list

Threaded View

1tane1 A VBA code to add worksheets... 08-21-2014, 04:45 AM
Aaron092 Re: A VBA code to add... 08-21-2014, 04:56 AM
pareshj Re: A VBA code to add... 08-21-2014, 04:58 AM
1tane1 Re: A VBA code to add... 08-21-2014, 05:15 AM
pareshj Re: A VBA code to add... 08-21-2014, 05:20 AM
1tane1 Re: A VBA code to add... 08-21-2014, 10:01 AM
  1. 08-21-2014, 04:45 AM #1
    1tane1 is offline
    Forum Contributor
    Join Date
    01-08-2013
    Location
    ankara
    MS-Off Ver
    Excel 2010
    Posts
    134

    A VBA code to add worksheets with the names given as a list

    I have 86 names (actually numbers) listed in a range (say A1:A:86). I want to create a worksheet for each one of them. Is there an easy way to do? (adding multiple worksheets)
    1001
    1035
    2009
    2010
    3003
    3004
    3005
    3006
    4003
    5001
    6001
    ...
    Last edited by 1tane1; 08-21-2014 at 05:16 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code to select worksheets based on sheet names in a list
    By cdself in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2013, 01:00 PM
  2. Create new worksheets with names from a list
    By daniel_t in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2013, 03:21 AM
  3. Code to List all worksheet names (tab names)
    By howard101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2007, 12:51 PM
  4. Generating worksheets from a list of names with VBA
    By pvandijk in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-26-2007, 09:46 AM
  5. how do i list the names of all my worksheets
    By tthe in forum Excel General
    Replies: 2
    Last Post: 11-17-2005, 02:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1