title: How do I reference this sheet using an index instead of the worksheet name?
body: <p>See the code snippet below. I'm basically just looking for how I might select the same sheet Previous Month without using a hardcoded name.</p>
  <pre><code>ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R4C4+RC[-4]&quot;
  </code></pre>
  <p>I tried it this way once and it didn't seem to work for me:</p>
  <pre><code>ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]'(1)!R4C4+RC[-4]&quot;
  </code></pre>
  <p>Error: <a href="https://i.stack.imgur.com/UZ1hC.png" rel="nofollow noreferrer">Error I received</a></p>
  <p>Any thoughts? I just don't want to have to manually type in Previous Month for the worksheet name if I can help it, would rather reference it with an index.</p>
  <p>Per requests I added a little bit more code and the error. I'm trying not to add the full code because the full code is extremely long, does multiple things, and I don't want to distract from the main reason I asked this question.</p>
  <pre><code>Sheets(&quot;Month Raw Data&quot;).Select
  Range(&quot;H4&quot;).Select
  Application.CutCopyMode = False
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R4C8+RC[-4]&quot;
  Range(&quot;H4&quot;).Select
  Selection.Copy
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  Range(&quot;H5&quot;).Select
  Application.CutCopyMode = False
  Application.CutCopyMode = False
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R5C8+RC[-4]&quot;
  Range(&quot;H5&quot;).Select
  Selection.Copy
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  Range(&quot;J4&quot;).Select
  Application.CutCopyMode = False
  Application.CutCopyMode = False
  ActiveCell.FormulaR1C1 = &quot;=(((RC[-2]-RC[-1])/RC[-1])*100)&quot;
  Range(&quot;J5&quot;).Select
  Application.CutCopyMode = False
  ActiveCell.FormulaR1C1 = &quot;=(((RC[-2]-RC[-1])/RC[-1])*100)&quot;
  Range(&quot;H8&quot;).Select
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R8C8+RC[-4]&quot;
  Range(&quot;H9&quot;).Select
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R9C8+RC[-4]&quot;
  Range(&quot;H10&quot;).Select
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R10C8+RC[-4]&quot;
  Range(&quot;H11&quot;).Select
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R11C8+RC[-4]&quot;
  Range(&quot;H8&quot;).Select
  Selection.Copy
  Range(&quot;H4:H5&quot;).Select
  Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
      SkipBlanks:=False, Transpose:=False
  Application.CutCopyMode = False
  Range(&quot;H14&quot;).Select
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R14C8+RC[-4]&quot;
  Range(&quot;H15&quot;).Select
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R15C8+RC[-4]&quot;
  Range(&quot;H17&quot;).Select
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R17C8+RC[-4]&quot;
  Sheets(&quot;Month % Change&quot;).Select
  Range(&quot;I29&quot;).Select
  ActiveCell.FormulaR1C1 = _
      &quot;='[Previous Month''s Public Numbers.xls]Previous Month'!R[-26]C[8]+RC[-5]&quot;
  Range(&quot;I29&quot;).Select
  Selection.AutoFill Destination:=Range(&quot;I29:I50&quot;)
  Range(&quot;I29:I49&quot;).Select
  Range(&quot;I29:I50&quot;).Select
  Selection.Copy
  </code></pre>