+ Reply to Thread
Results 1 to 3 of 3

vba macro to batch process adding worksheets

  1. #1
    Registered User
    Join Date
    04-14-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    36

    vba macro to batch process adding worksheets

    Hi Experts,


    In need of your help as usual. I have a manually triggered code to manually create a new worksheet by manually entering the sheet name and the code checks for duplicates, copies master template sheet and renames it to newly entered name.

    Now, I need a batch processing vba code to look at my names list in a range e.g A:A take each value, trigger my macro and enter the referenced name into it then letting the macro create a sheet and name it and then move on to the next name on the list.

    This is my current macro code to add a new sheet:

    Please Login or Register  to view this content.
    Thanks in advance...

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: vba macro to batch process adding worksheets

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-14-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    36

    Re: vba macro to batch process adding worksheets

    Many thanks JOHN H. DAVIS... your code worked a treat.... and I've customised it to my activity.

    Just 1 more additional cry for help, how do I amend the code to first check if the sheet with the same name exists and if so skip the addition and move to the next. This is my code which is copying and renaming a master template:

    Please Login or Register  to view this content.
    Oh. I could also do with code to reverse this and batch search and delete sheets. I know I ask for too much but I'm a newbie to vba it may take me 3 hours to work out how to doe it when experts take 3-5 so your help is greatly appreciated.


    Thanks in Advance..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adapt macro to batch process files
    By beng404 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2012, 07:09 PM
  2. VBA Macro to process duplicate phone numbers in 3 worksheets
    By delforum in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-07-2011, 11:02 AM
  3. Reverse Geocode Batch Process
    By ernestgoh in forum Excel General
    Replies: 0
    Last Post: 01-19-2010, 03:35 PM
  4. Batch renaming of worksheets
    By Lumen S in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 03:40 PM
  5. Can I batch rename new worksheets
    By Harry Limey in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-19-2005, 06:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1