title: AutoFit when using VLOOKUP to fill a cell
body: <p>With “autofit” set, one is able to let the height or width adjust accordingly to whatever you enter.<br />
  The cell size should be updated after entering new data.</p>
  <p>This is not the case with cells that use the &quot;VLOOKUP&quot; function. The dimensions of the cells stay the same unless you manually hit “autofit height” or “autofit width” again.</p>
  <p>My workaround is code that selects all cells and adjusts the dimensions.</p>
  <pre class="lang-vb prettyprint-override"><code>Cells.Select
  Selection.Rows.AutoFit
  </code></pre>
  <p>Is this the only way to change the behaviour of Excel (2013 Version)?</p>