+ Reply to Thread + Post New Thread
Results 1 to 2 of 2

Delete all sheets except the active one...?

  1. #1
    derobin
    Guest

    Delete all sheets except the active one...?

    "Delete all sheets except the active one...?"
    How can I do that in VBA, anyone?

    thx Robin


  2. #2
    Jim Thomlinson
    Guest

    RE: Delete all sheets except the active one...?

    Try this...

    dim wks as worksheet

    application.displayalerts = false
    for each wks in worksheets
    if wks.name <> activesheet.name then wks.delete
    next wks
    application.displayalerts = true

    --
    HTH...

    Jim Thomlinson


    "derobin" wrote:

    > "Delete all sheets except the active one...?"
    > How can I do that in VBA, anyone?
    >
    > thx Robin
    >
    >


+ Reply to Thread + Post New Thread

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