5 Comments Add yours

  1. Tamer says:

    Couldn’t one use a snippet like the one below?

    If ws.Name ‘sheet not to be deleted’ Then
    Kill ws
    End If

    1. Tamer says:

      If ws.Name ‘sheet not to be deleted’ Then
      Kill ws
      End If

      A not equal to comparator was left out b/w ws.Name and “sheet…

  2. Hi Tamer,
    can use a loop with your code.. but the challenge was to delete them without loop, kris has replied very smartly, you can also visit the link below :

    http://www.excelfox.com/forum/f13/delete-worksheets-without-loop-515/#post2056

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s