Posted to microsoft.public.excel.programming

bartman1980 bartman1980 is offline

external usenet poster

Posts: 34

delete drwaings in a centain selection

I try to delete all the drawings in a certain selection.

sub deletedrawings()
Range("A60:H60").Select
Range("H60").Activate
Range(Selection, Selection.End(xlDown)).Select
activecells.DrawingObjects(1).Delete
Selection.ClearContents
end sub

But I get an error with the line
activecells.DrawingObjects(1).Delete

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
delete a selection	flirtacious	Charts and Charting in Excel	2	November 25th 07 01:57 PM
Problem of selection.delete	Radhakrishna k.v.n.r[_2_]	Excel Worksheet Functions	7	October 27th 07 11:50 AM
Copy Selection - Paste Selection - Delete Selection	Uninvisible	Excel Programming	2	October 25th 07 01:31 PM
Copy Selection - Transpose Selection - Delete Selection	Uninvisible	Excel Discussion (Misc queries)	2	October 23rd 07 04:18 PM
Delete blank rows in selection	Jim Thomlinson[_5_]	Excel Programming	0	February 13th 06 08:40 PM

All times are GMT +1. The time now is 01:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us