Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
Clearing #N/A's in one go? | Excel Worksheet Functions | |||
Clearing #VALUE | Excel Worksheet Functions | |||
How to insert small colored dots or rectangles in cells of excel | Excel Discussion (Misc queries) | |||
ClearContents not clearing :( | Excel Programming |