Hello,
I have a button that inserts a new row in a big database, clears contents from previous row and in the same time keeps formulas where needed.
I need to make it to clear the colour of the cell in column F in the new row - to became from yellow or green to No fill.
Do you have any suggestions?
here is the code that i have so far:
Private Sub CommandButton1_Click()
With Me.CommandButton1.TopLeftCell.Offset(-1, 0).EntireRow
.Insert Shift:=xlDown
.Offset(-2, 0).AutoFill Destination:=Range(.Offset(-2, 0), .Offset(-1, 0)), Type:=xlFillDefault
.Offset(-1).Range("B1:O1,T1:Z1").ClearContents
End With
End Sub
Bookmarks