Re: Cell sizing in a Vlookup formula to fit information.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Could you resize all the usedrange's rowheights each time excel recalculates?

If yes, rightclick on the work*** tab that should have this behavior. Select
view code and paste this in:

Option Explicit
Private Sub Worksheet_Calculate()
Me.UsedRange.Rows.AutoFit
End Sub

If you don't want to do all the rows, you can specify the ones you want:

Option Explicit
Private Sub Worksheet_Calculate()
Me.UsedRange.Range("a5:a12").EntireRow.AutoFit
End Sub

(It resizes 5:12 and leaves the rest alone.)

Mike wrote:

Is it possible for a cell to automatically size itself by height to fit the
information pulled into said cell by a VLookup formula. The information in
my data table are of differing lengths. I currently have to stop working in
my spread*** to size the cells by height to visually see all the
information.

--

Dave Peterson
.

Quantcast