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