Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2000 - Use macro to delete objects

Status
Not open for further replies.

harrier2

Technical User
Nov 6, 2002
10
GB
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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top