Murray Brown
asked on
VBA Delete DropDowns in cells
Hi. I am using code like that shown below to add cells to a hundred cells in the top
row of a spreadsheet. What code would I use to delete all DropDowns in the top row of the sheet
Sub DD()
With ActiveSheet.DropDowns.Add( 142.5, 38.25, 108.75, 24)
.Top = Range("C1").Top
.Left = Range("C1").Left
.Height = Range("C1").Height
.Width = Range("C1").Width
End With
End Sub
row of a spreadsheet. What code would I use to delete all DropDowns in the top row of the sheet
Sub DD()
With ActiveSheet.DropDowns.Add(
.Top = Range("C1").Top
.Left = Range("C1").Left
.Height = Range("C1").Height
.Width = Range("C1").Width
End With
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER