clearing cells

[vertx93]

Hi everyone, New here..

I would like to know how to clear a range of cells (eg. A1 to E5) when changing another cell (eg. F1) thanks!!

 

[steve the fish]

This in the worksheet module should do it (right-click on the sheet tab and press view code):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$1" Then
Range("A1:E5").ClearContents
End If

End Sub