Deleting objects within a certain range

[JohnnyBGood]

Hi all,

What is the best way to delete drawing objects within a certain range.

Say I have several pictures contained with range E3:J7 and I want to use a macro to delete them at will. Can this be done.

I tried recording a macro that goes to Edit|Go To|Special|Objects, but I couldn't revise it to be limited to a certain range. There are other objects in the sheet that I do not want to delete.

Thanks for any advice.

[Leith Ross]

Hello JohnnyBGood,

Here is macro to delete pictures by range. Pictures within the given range will be deleted.

Example: DeletePics Range("E3:J7")

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[JohnnyBGood]

Thanks for that Leith. Much appreciated.

Is it possible to revise the code so the the range is fixed (i.e. Range("E3:J7") always). I want to put this within a larger code and I will always be deleting pics in that fixed range (not based on user selection).

Thanks again.

[JohnnyBGood]

Anybody got any hints how I can use a fixed range in the code to delete the pictures within that range? I'm having difficulty altering the code given by Leith Ross to do that.

Thanks.

[JohnnyBGood]

Okay, nevermind.....

I found some code here: http://www.mvps.org/dmcritchie/excel/shapes.htm that suits my needs.

Here's the code by Dave Peterson.

Please Login or Register  to view this content.