title: Excel vba How best to determine if .usedrange is empty
body: <p>is there a quick way to determine, if <code>.usedrange</code> does actually return something?</p>
  
  <p>A short example:</p>
  
  <pre><code>Dim wsKtE as worksheet
  Dim KtE() As Variant
  
  set wsKtE = ActiveSheet    
  KtE = wsKtE.UsedRange
  </code></pre>
  
  <p>if there is no data in wsKtE I get a type does not match exception. I found, that I could that if both <code>wsKtE.usedrange.columns.count</code> and <code>wsKtE.usedrange.rows.count</code> are 1, than I can infer that the area is probably empty.</p>
  
  <p>Is there a better way?</p>
  
  <p>Thx Kaz</p>