| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a sheet if it exists?
Me again! Flying along nicely, apart from... In a macro i have: Sheets("Completed Orders").Delete Sheets("Partially Arrived Orders").Delete Sheets("Draft Orders").Delete Sheets("Placed Orders").Delete But coming from another macro that's already deleted them (in som cases only).. How would i say IF sheet "completed orders" exists then delete else not to worry Thanks al -- druce ----------------------------------------------------------------------- drucey's Profile: http://www.excelforum.com/member.php...fo&userid=3255 View this thread: http://www.excelforum.com/showthread.php?threadid=52354 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet name already exists | Excel Discussion (Misc queries) | |||
| Sheet Exists in another file? | Excel Programming | |||
| Rename sheet if exists | Excel Programming | |||
| How can I know if a sheet exists ? | Excel Programming | |||
| Testing to see if a sheet name exists | Excel Programming | |||
![drucey[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
