Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I programmatically delete a named range which contains checkboxes, but after
the rows have been deleted the checkboxes overlay each other and appear in a blank line. Is there any way to delete the checkboxes as well as the content of the cells/rows? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Maybe you could do something like:
Option Explicit Sub testme99() Dim myShape As Shape Dim myRng As Range Dim wks As Worksheet Set wks = Worksheets("Sheet1") With wks Set myRng = .Range("g8:k20") 'whatever For Each myShape In .Shapes If Intersect(myShape.TopLeftCell, myRng) Is Nothing Then 'don't delete it Else myShape.Delete End If Next myShape End With myRng.Delete shift:=xlUp End Sub Jazzi-D wrote: I programmatically delete a named range which contains checkboxes, but after the rows have been deleted the checkboxes overlay each other and appear in a blank line. Is there any way to delete the checkboxes as well as the content of the cells/rows? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |