Thread
:
Delete worksheet if cell is empty
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Delete worksheet if cell is empty
Are you trying to delete ONE sheet or any sheet in the workbook where cell
a12 is empty?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"RU0824V" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett