Deleting objects within a certain range

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.

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

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.

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.

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.