title: How to declare an Active Worksheet in a variable?
body: <p>I'm trying to keep a variable to the currently open worksheet in VBA. So far I have </p>
  
  <pre><code> Dim Active As Worksheet
   Set Active = ActiveWorksheet 
  </code></pre>
  
  <p>For some reason it gives me an error in the last line, saying Object required. My code opens a new worksheet with the data in the Active sheet, so I need a variable to hold my place in the currently active worksheet. Any idea why this isn't working correctly?</p>