ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Delete object code (https://www.excelbanter.com/excel-discussion-misc-queries/229239-delete-object-code.html)

Marie Bayes

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

Marie Bayes

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



All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com