So I am trying to write some formating macro's.
One of them is to delete entire rows, but the rows each contain a
Checkbox. I have a snippit of code to remove checkboxes:
Dim chbx As String
Dim strt, fin As Integer
strt = 734
fin = 1790
For i = strt To fin
chbx = "Check Box " & i
On Error Resume Next
ActiveSheet.Shapes(chbx).Select
Selection.Cut
Next i
The problem that I have is, that I do not know how to obtain the start
and end number for the checkboxes in the range I want to delete. Is
there a method to delete an entire row and the objects within it?
Thanks,
Phil
--
pkohler
------------------------------------------------------------------------
pkohler's Profile:
http://www.excelforum.com/member.php...fo&userid=8919
View this thread:
http://www.excelforum.com/showthread...hreadid=385700