Delete object code

M

Marie Bayes

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.
 
M

Marie Bayes

Sorry, have solved it with an if statement, hope no-one's spent any time on
this one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top