Thread: select and delete all pictures in a given range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default select and delete all pictures in a given range
Pictures "float" above the cells.

But you can find if they "hide" cells:

http://groups.google.com/group/micro...539a3aca31dcd7
--
Gary''s Student - gsnu200765


"the excel-arator" wrote:

I would like to be able to have VBA for excel delete all the pictures on a
given worksheet, but only in a certain range of that sheet. Is this possible?
ie. delete the pictures found only in the range A5:C25

Worksheets("Sheet2").Range("A5:C25").Shapes.Select All
Selection.Delete

'That baby doesn't work, but is there perhaps something similar that might
do the trick?

Any help is appreciated,

Thanks!

John
Reply With QuoteReply With Quote