Delete worksheet if cell is empty
Hello,
I have figured out how to delete a sheet if a cell contains no data
(although it does not seem to work consistently), but I cannot figure out how
to stop the next section of code if the sheet is deleted. The code for the
deleted sheet (if it had contained data) gets applied to the next worksheet.
Here is what I have for the deletion...should this be followed by "else" or
something? I am tyring to say "if cell A12 has no data, delete the worksheet"
If IsEmpty(Range("A12")) Then SelectedSheets.Delete
Thanks!
Kathy
--
RU0824V
|