Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell sizing in a Vlookup formula to fit information.
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 spreadsheet to size the cells by height to visually see all the information. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell sizing in a Vlookup formula to fit information.
Could you resize all the usedrange's rowheights each time excel recalculates?
If yes, rightclick on the worksheet 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 spreadsheet to size the cells by height to visually see all the information. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell sizing in a Vlookup formula to fit information.
Dave, You are a genius. That was totally helpful and solved my dilema. I
thank you very much. "Dave Peterson" wrote: Could you resize all the usedrange's rowheights each time excel recalculates? If yes, rightclick on the worksheet 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 spreadsheet to size the cells by height to visually see all the information. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic cell Formating ina VLookup formula | Excel Worksheet Functions | |||
Using cell information in formula? | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |