title: Excel VBA Run Time Error '424' object required
body: <p>I am totally new in VBA and coding in general, am trying to get data from cells from the same workbook (get framework path ...) and then to start application (QTP) and run tests.</p>
  
  <p>I am getting this error when trying to get values entered in excel cells:</p>
  
  <pre><code>Run Time Error '424' object required
  </code></pre>
  
  <p>I believe I am missing some basic rules but I appreciate your help.  Please see below the part of code in question:</p>
  
  <pre><code>Option Explicit
  
  Private Sub RunTest_Click()
  
      Dim envFrmwrkPath As Range
      Dim ApplicationName As Range
      Dim TestIterationName As Range
      'Dim wb As Workbook
      'Dim Batch1 As Worksheets
      Dim objEnvVarXML, objfso, app As Object
      Dim i, Msgarea
  
      Set envFrmwrkPath = ActiveSheet.Range("D6").Value ' error displayed here
      Set ApplicationName = ActiveSheet.Range("D4").Value
      Set TestIterationName = ActiveSheet.Range("D8").Value
  </code></pre>