View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew B[_5_] Andrew B[_5_] is offline
external usenet poster
 
Posts: 7
Default Clearing rectangles

Hi

I have a number of rectangles that I want to delete from an area on a
worksheet. What is the quickest way to do this ?

I have tried the following but it didn't quite work ...

Sub rem1()
Set Shr = Sheets("Reports")


For Each Rectangle In Shr.Range("B26:V53") ' graph area
Rectangle.Delete
Next

End Sub


Thanks in advance

Andrew B