title: Read cell and use text as input for VBA formula
body: <p>I've been searching for a long time now to find a simple solution for my problem but I just can't find it. My problem is that I want to reference a cell and use it as text in my VBA code.</p>
  
  <p>eg:
  say the cell = C104</p>
  
  <p>VBA would do:</p>
  
  <pre><code>wb2.Sheets("Cell").Range("F8:F22").Copy
  wb1.Sheets("asd").Range("B7:B21").PasteSpecial
  </code></pre>
  
  <p>This doesn't work because it isn't actually using the text from the cell. I've tried using <code>cell().Text</code> and <code>.value</code> but they don't work.</p>