title: "Subscript out of Range" when attempting to copy worksheet
body: <pre><code>Private Sub Add_Click()
  ActiveWorkbook.Worksheets(ComboBox1.Value).Copy Before:=Workbooks(link.Value).Worksheets("Contract")
  End Sub
  </code></pre>
  
  <p>This is the I am 100% sure that link and ComboBox1 have the values that I'm looking for.  </p>
  
  <p>Can someone tell me why I keep getting the error "<em>Subscript out of Range</em>"?</p>