title: VBA code does not jump to cell
body: <p>Hy I am trying to make a code that jumps to a cell. </p>
  
  <p>The address is stored in a variable. </p>
  
  <p>I tried 2 options, but both do not work with the variable.</p>
  
  <p>They work fine with the concrete cell address.</p>
  
  <pre><code>Dim stMsg As String
  Dim x As String
  
   x = Left(stMsg, Len(stMsg) / 2) 'x = 'Sheet2'!$C$8
  
      '1 Option
      Application.Goto Reference:="x" 'this works with format: Sheet2!R8C3
  
      '2 Option
      With Range("x")  'this works with format: 'Sheet2'!$C$8 , which is exactly x
      .Parent.Activate
      .Activate
      End With
  </code></pre>
  
  <p>It gives me </p>
  
  <blockquote>
    <p>Method 'Range' or object'_Global' failed" error.</p>
  </blockquote>
  
  <p><code>stMsg</code> is a variable found in the first part of the macro. The first part take a formula in a cell and find the precedents in the formula, which are 2. <code>stMsg</code> stores them both, that's why I split it with x. The value of <code>stMsg</code> is 'Sheet2'!$C$8'Sheet2'!$C$8</p>
  
  <p>How can I make it work with x?</p>