Deleting specific shapes not all in excel - Macro

[Mhay5656]

Hi

I need a macro that deletes/removes specific shapes in an excel spread sheet.

The problem is the i want to remove shapes / object ( jpegs with signatures) and not the Jpeg that is a logo for each letter.

I have a macro that copies a object (signatures) and pastes to a range for each letter in the same sheet. Then I need to remove the objects (signatures) once printed leaving the main signatures and logos.

I tried recording a macro but it didn't work. The best way to do this would be to name the range where the shapes are situated and remove.

I have a macro that copy and paste the shapes from another column outside the letter therefore the picture name changes with every new paste so I can not select by picture name eg(number) picture 1

range(a2:c2)
Range(a25:c25) and so on

There might be some ranges that are blank so this might cause the macro to error.

The other option is to name the objects(logos) in the column of the letter that are to stay and delete the remainder
Thank you in advance.

[radddogg]

Can you upload a cleansed sample workbook?

[Mhay5656]

Hi

I have uploaded my file,

Thank you for your help

[Mhay5656]

Please see above attached file
Thank you

[radddogg]

Sorry for not getting back to you. I'll have a look at this today.

[radddogg]

Hi,

Insert the below into a module and assign to your "Remove Signatures" button.

Please Login or Register  to view this content.

There are other ways to optimise your code if you are interested, such as using the name dropdown in conjunction with a "Refresh" button, choose the signature based on a variable. At the moment you have a separate button and macro to populate each signature.

If you would like me to have a go, please let me know.

Regards Radddogg

[Mhay5656]

Thank you Radddogg, it worked prefectly