'AutoFit when using VLOOKUP to fill a cell
With “autofit” set, one is able to let the height or width adjust accordingly to whatever you enter.
The cell size should be updated after entering new data.
This is not the case with cells that use the "VLOOKUP" function. The dimensions of the cells stay the same unless you manually hit “autofit height” or “autofit width” again.
My workaround is code that selects all cells and adjusts the dimensions.
Cells.Select
Selection.Rows.AutoFit
Is this the only way to change the behaviour of Excel (2013 Version)?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|