View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marie Bayes Marie Bayes is offline
external usenet poster
 
Posts: 84
Default 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