Posted to microsoft.public.excel.programming

the excel-arator[_2_] the excel-arator[_2_] is offline

external usenet poster

Posts: 3

select and delete all pictures in a given range

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select a range of rows to delete	Donna[_3_]	Excel Worksheet Functions	2	January 26th 10 07:32 PM
Select Data by Date Range, Delete Rest	Learner	Excel Programming	2	January 21st 07 03:42 AM
delete pictures	VilMarci	Excel Programming	2	February 18th 05 09:56 AM
debug message pops up when I select a range of cells and delete	Brian	Excel Programming	6	October 17th 04 12:55 AM
How do I select a whole range and delete the contents of the cells?	benthomas_duck	Excel Programming	2	June 4th 04 02:31 AM

All times are GMT +1. The time now is 05:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us