View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bartman1980 bartman1980 is offline
external usenet poster
 
Posts: 34
Default 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