title: How do I get a range's address including the worksheet name, but not the workbook name, in Excel VBA?
body: <p>If I have a Range object--for example, let's say it refers to cell <code>A1</code> on a worksheet called <code>Book1</code>.  So I know that calling <code>Address()</code>  will get me a simple local reference: <code>$A$1</code>.  I know it can also be called as <code>Address(External:=True)</code> to get a reference including the workbook name and worksheet name: <code>[Book1]Sheet1!$A$1</code>.</p>
  
  <p>What I want is to get an address including the sheet name, but not the book name.  I really don't want to call <code>Address(External:=True)</code> and try to strip out the workbook name myself with string functions.  Is there any call I can make on the range to get <code>Sheet1!$A$1</code>?</p>