I have produced a spread sheet which will calculate where to put lashings on different types of loads carried for security.
There is then a macro which will draw an object based on these results to show where to attach the lashings.
I have tried to create a macro which will delete these objects prior to recalculating for different loads.
I get an error that says object not found when ever I run the macro. Can I write a code that will delete any object within a range of cells? Below is the code used.
Selection.Delete
ActiveSheet.Shapes("Group 24208"
.Select
Selection.Delete
ActiveSheet.Shapes("Rectangle 24207"
.Select
Selection.Delete
Thank you
Tim
There is then a macro which will draw an object based on these results to show where to attach the lashings.
I have tried to create a macro which will delete these objects prior to recalculating for different loads.
I get an error that says object not found when ever I run the macro. Can I write a code that will delete any object within a range of cells? Below is the code used.
Selection.Delete
ActiveSheet.Shapes("Group 24208"
Selection.Delete
ActiveSheet.Shapes("Rectangle 24207"
Selection.Delete
Thank you
Tim