| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete object code
Hi
I have the following code: ActiveSheet.DrawingObjects.Select Selection.Delete However, if there are no objects to delete the code deletes the cell currently in focus. Is there any code that I can put in that if objects are found to select that it won't then delete anything...? Thanks in advance. -- Marie Bayes |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete object code
Sorry, have solved it with an if statement, hope no-one's spent any time on
this one. -- Marie Bayes "Marie Bayes" wrote: Hi I have the following code: ActiveSheet.DrawingObjects.Select Selection.Delete However, if there are no objects to delete the code deletes the cell currently in focus. Is there any code that I can put in that if objects are found to select that it won't then delete anything...? Thanks in advance. -- Marie Bayes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete code | Excel Discussion (Misc queries) | |||
| delete code keeps going and coing | Excel Discussion (Misc queries) | |||
| Chart Object VB Code | Charts and Charting in Excel | |||
| code to delete rows | Excel Discussion (Misc queries) | |||
| Cannot delete object | Excel Discussion (Misc queries) | |||
Linear Mode
