VBA Excel VBA Challenge Posted by Rajan Verma on August 14, 2012 Hi Guys, Challenge is to Delete all Sheets Except one without any loop and mapping table Keep Excelling Share this:TwitterFacebookLinkedInMoreEmailPrintLike Loading...
My reply posted here:
http://www.excelfox.com/forum/f13/delete-worksheets-without-loop-515/#post2056
Couldn’t one use a snippet like the one below?
If ws.Name ‘sheet not to be deleted’ Then
Kill ws
End If
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…
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