Delete Object when Object number unknown

i recorded the following macro to delete and object on a worksheet, yet the object number is not always the same.

Please Login or Register  to view this content.

i tried using

Please Login or Register  to view this content.

yet received an error. any suggestions on how to select an object when the object name (it will always be "Object #") is unknown?

If you don't have a way of identifying which object you want to select then your in a bit of difficulty.

each shape is in the 'shapes' collection. You can cycle through the shapes easily enough with a couple of methods:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You could put in yes/no message box or something so that you stop when the correct shape is selected I suppose.

What is it you are trying to do exactly?

hello chergh

i'm trying to reset a sheet that contains data, formula and objects. i'm using clearcontents to reset the sheet, yet the object is not cleared with this.

i guess your first code will identify the objects on the sheet, such that i can then clear it?

If you just want to delete every shape in your spreadsheet then use:

Please Login or Register  to view this content.

If you want to clear every worksheet in your workbookof shapes use:

Please Login or Register  to view this content.

i want to delete every shape in the active worksheet only... so if i change "worksheets("Sheet1")" to activesheet it should do the trick?

Yeah it should do.

it did. thanks for your help chergh