Worksheet Change VBA

[Mighty Whites]

Hi,

I want to input some VBA coding which removes the contents of a certain cell only if a different certain cell is changed. If any other cell is changed I want the sheet to remain as it is.

I tried the following and don't know how far I am away form making it work...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = ("G4") Then Range("G7").ClearContents Else End
End
End Sub

Any help would be most appreciated.

Thanks!

 

[MrKowz]

When you use the .Address method, it actually returns the absolute reference string for the cell:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$4" Then Range("G7").ClearContents
End Sub