title: Excel Error in VBA " Run-time error '424': Object required at SET statement
body: <p>I'm getting Run-time error '424' at the last line of the code and cannot undertand why. Any help please.</p>
  <pre><code>Dim sourceSh As Worksheet
  Dim destSh As Worksheet
  Dim FileName As String
  Dim destWk As Workbook
  Dim sourceWk As Workbook
  
  FileName = &quot;Data.xlsx&quot;
  
  Set destWk = Workbooks.Open(FileName)
  Set sourceWk = DataEntry
  Set sourceSh = sourceWk.Sheets(Data_Entry.Name)  'why here I'm not getting error !!
  Set destSh = destWk.Sheets(Employees.Name)      'here I'm getting Run-time error 424. 
  </code></pre>
  <p>I have cotroled speel check and everything looks fine.</p>