If text exists in worksheet cell, delete worksheet

[Lizard07]

Hi - I need a macro that will loop through each worksheet, finds a cell that contains the word "Hook:", and then delete that worksheet. There is some other specifications (listed below)

1) I would like it to loop through all worksheets except two, "Control Panle" and "Master"
2) I would like to only delete the worksheets when the text "Hook:" if followed by numeric text, i.e.

Hook: 7843549387 - DELETE
Hook: Unknonwn - DO NOT DELETE
3) The range for which the macro should search is column 8 of each worksheet.

Please let me know if you can help
thanks!

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=567732

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).