Excel 2000 - Use macro to delete objects

[harrier2]

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&quot.Select
Selection.Delete
ActiveSheet.Shapes("Rectangle 24207&quot.Select
Selection.Delete


Thank you

Tim

 

[Chattin]

This may be relevant

http://www.mrexcel.com/board2/viewtopic.php?t=54947&highlight=delete+shape

HTH

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help