title: VBA - Using RefEdit as Range
body: <p>I have a VBA script which opens a UserForm so the user can select various cell addresses for copying information from one file to another.  I am using RefEdit controls to designate the cell address, but I am receiving an object error when I try to use the <code>Workbook.Range(UserForm.RefEdit.Value)</code> function, because the RefEdit reference is in the format "'Sheet1'!X#:X#".  I know that if the RefEdit were just a range of cells I could do <code>Workbook.Worksheet.Range(UserForm.RefEdit.Value)</code>, but the VBA script is being used for transitioning multiple files with different sheet names (so I can't use a universal <code>Workbook.Worksheet</code> string).  Is there any way to use the RefEdit reference with both sheet name and cell address as a range?</p>
  
  <p>Here is my current code:</p>
  
  <pre><code>Sub ReviseFAA()
  Dim FolderPath As String, FilePath As String
  Dim SourceFAA As Workbook, RevisedFAA As Workbook
  
  FolderPath = "A:\Copy of MWO File\"
  FilePath = Dir(FolderPath &amp; "*.xls")
  
  Do While FilePath &lt;&gt; ""
      Workbooks.Open (FolderPath &amp; "FAA Template.xlsx")
      Set RevisedFAA = Workbooks("FAA Template.xlsx")
      Workbooks.Open (FolderPath &amp; FilePath)
      Set SourceFAA = Workbooks(FilePath)
  
      FAA_User.Show
  
      With SourceFAA
      RevisedFAA.Sheets("Repair Instruction").Range("U2:AD3") = .Range(FAA_User.ControlNumber.Value).Value
      End With
  
      FilePath = Dir
  Loop
  </code></pre>