Results 1 to 3 of 3

Delete Worksheets Based On Name

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2011
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2010
    Posts
    82

    Delete Worksheets Based On Name

    Hi all,

    Hopefully this is a fairly simple one. I have a workbook with a huge amount of sheets. A number of these contain the word 'Urgent' - Urgent(2), Urgent(3), etc - and I wish to delete any sheet that contains this word. Rather than go through and delete each individually, can anyone suggest a piece of code that might do this in one go?

    TIA,

    Fermented R
    Last edited by Fermented Reptile; 01-18-2012 at 11:03 AM.

Thread Information

Users Browsing this Thread

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

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