title: Get name of an Excel worksheet containing code
body: <p>I have code that resides on a page and references the content of the workbook. When executed from a different worksheet, I would like to get the name of the specific Worksheet containing the code.</p>
  
  <p>I have worksheets that contain data. The code is added to that worksheet and the run - which produces a Summary worksheet. From the Summary worksheet, I would like to run the code on the data worksheet. This means I can't use <code>ActiveSheet</code> and I would have to reference the data sheet by  name. </p>
  
  <p>How can I get the name of the worksheet containing the code without having to hard-code the name?</p>