Find value and remove/delete

[Fwiz]

I'm trying to figure out how to remove a value from a list using VBA, i have a name range for input, what ever is captured in that cell should automatically be deleted/cleared from worksheet 2 - column G

any ideas on how?

 

[Fwiz]

my first attempt was this:
Dim c As Range
For Each c In Range("g2:g200")
With c
If .Value = "i3" Then .ClearContents
End With
Next c
the code doesnt recognise the value in the cell reference I3 to remove the matching value from the list...

 

[Fwiz]

Doh!! here is the correct version..

Dim c As Range
For Each c In Range("G2:G200")
With c
If .Value = Range("i3") Then .ClearContents
End With
Next c

Managed to figure out something soooo obvious!! anyway for those who may need something similar for the future!