title: Sheet_variable.UsedRange.Column does not give the expected/desired result. Why?
body: <p>I'm interested in using a variable of type workbook in Excel VBA where I would hold an Excel file like this:</p>
  
  <pre><code>Set mWB = Application.Workbooks("C:\Central.xlsx")
  </code></pre>
  
  <p>and then I would like to hold a worksheet from this file similarly in a Sheet variable.</p>
  
  <pre><code>Set aWS = mWB.Sheets("Sheet1")
  </code></pre>
  
  <p><strong>In Sheet1 inside Central.xlsx, I have values in Range(A1:D6)</strong></p>
  
  <p>However, when I do this: <code>MsgBox aWS.UsedRange.Column</code> , I get 1. <strong>I was expecting 6 (6 populated rows)</strong>
  and when I do this: <code>MsgBox aWS.UsedRange.Row</code> I get 1 again. <strong>I was expecting 4 (4 populated rows).</strong></p>
  
  <p>Where is the mistake please?</p>