Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need to delete empty pages in my worksheet | Excel Discussion (Misc queries) | |||
how do i find and delete all empty rows in an excel worksheet | Excel Worksheet Functions | |||
How do I delete an empty worksheet. | Excel Worksheet Functions | |||
How to delete empty rows in a worksheet | Excel Programming | |||
Delete empty rows in a worksheet | Excel Programming |