title: VBA: Delete target row if cell contains text?
body: <p>I have a spreadsheet like so:</p>
  
  <p>Column Y
  Remove
  Remove
  Remove
  Remove</p>
  
  <p>I want the user to be able to delete each row by clicking each of the remove texts. This should delete only the row which the user has clicked remove for, aka the target row.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   If Target.Column = 25 And Target.Value = "Remove" Then
  Range("A" &amp; ActiveCell.Row).EntireRow.Delete
   End If
  End Sub
  </code></pre>
  
  <p>for some reason this does nothing.</p>
  
  <p>I also want to add a condition which only deletes those rows from row 17 onwards.</p>
  
  <p>Please can someone show me how to get this working correctly? thanks</p>