title: VBA Offset Match Not Working
body: <p>I am trying to run a goal seek setting a certain cell equal to zero by changing another cell in Excel with VBA. </p>
  
  <p>The cell I want to set to zero changes location so I need to use a match offset combination I think.</p>
  
  <p>I get a compile error Invalid qualifier when I run the code though. Any ideas? </p>
  
  <p>Thank you.</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  
  Dim x As Integer
  x = Application.WorksheetFunction.match("G3", Range("I6:SF6"), 0).Value
  
  Range("I199").Offset(0, x.Value).GoalSeek Goal:=0, ChangingCell:=Range("GN197")
  
  
  End Sub
  </code></pre>