+ Reply to Thread
Results 1 to 3 of 3

Modify routine to add / delete sheets with names from input ranges

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    orange,ct
    MS-Off Ver
    2013
    Posts
    9

    Modify routine to add / delete sheets with names from input ranges

    The routine below renames tabs from input ranges.

    Need it modified to delete the sheet if user deletes the input, and vice versa, add a sheet with the name the user inputs

    Please Login or Register  to view this content.
    Thanks!!

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Modify routine to add / delete sheets with names from input ranges

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    06-18-2015
    Location
    orange,ct
    MS-Off Ver
    2013
    Posts
    9

    Re: Modify routine to add / delete sheets with names from input ranges

    Thanks works great - but - need to re-add and rename the deleted tab if user inputs a name

    thanks again!!

+ 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. How to modify routine to add / delete / rename tabs from input ranges
    By cvmelkus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2015, 03:08 PM
  2. Modify VBA code to change sheet tab names from input cells
    By cvmelkus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:15 PM
  3. Delete the same ranges in mutiple sheets
    By Dibbley247 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2015, 07:33 PM
  4. [SOLVED] Hide and delete sheets based on cell input
    By kokjinq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2014, 11:37 PM
  5. [SOLVED] Passing Multiple ranges to Sub Routine
    By madhatter40 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2013, 04:19 PM
  6. Replies: 2
    Last Post: 04-12-2012, 11:26 AM
  7. Copy and paste/ delete ranges from mulitpuls sheets macro
    By girt0n in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2012, 08:23 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1