title: determine if sheet change is in particular row
body: <p>I want to determine if a change to a sheet includes cells in one particular row.  I tried</p>
  
  <pre><code>Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
  
      Dim i As Integer
  
      If ActiveSheet.Name = "Yahoo" Then
          If Not Intersect(Target, Range(Cells([YahooID_Row], 1), Cells([YahooID_Row], 999))) Is Nothing Then
  
          Else
  
          End If
      End If
  
  End Sub
  </code></pre>
  
  <p>YahooID_Row is a named integer constant.</p>
  
  <p>I keep getting run time error 1004.  How do I do this?</p>