Deleting a sheet via code-- different criteria
Hi Again...
I've thought of a better way to remove unwanted worksheets from my
workbook....
I need to run code that will delete all worksheets in my activeworkbook that
have "Delete" in cell A3 of the worksheet.
Cell A3 has a formula in it of each worksheet that determines if the sheet
needs to be deleted or not... if it needs to be deleted.. then, the formula
returns "delete"...otherwise..it's blank "".
I think this will work better than my previous post......
I'm not sure how to do this ... so any help is greatly appreciated..
Thanks in advance,
Kimberly
|