View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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