AChimpNamedCornelius
Board Regular
- Joined
- Aug 22, 2002
- Messages
- 91
When you double-click the column separator (same thing for rows) right after the column, the column width will be set to just wide enough to display the widest entry in that column.
I want to be able to do this programatically from VBA. I have found nothing like this in any message. Setting the column width would, presumably, be easy, just set the width of a cell in that column (is this correct?)
However, I would prefer to avoid doing some tricky thing with fonts and getting the actual cell's display width and calculating the width of the string version of the cell, etc.
The reason I want to do this is because I have a file that may be edited by many people, and I want to set it up to a standard setup from the workbook open function every time it's opened. I've already figured out how to select the proper sheet, unscroll to the top, and select a blank, innocuous cell.
Speaking of which, are there quick programatic answers to related questions:
- Get the display value of a cell vs. the formula therein
- Copy and paste a formula in relative or absolute manner
This message was edited by AChimpNamedCornelius on 2002-09-09 14:05
I want to be able to do this programatically from VBA. I have found nothing like this in any message. Setting the column width would, presumably, be easy, just set the width of a cell in that column (is this correct?)
However, I would prefer to avoid doing some tricky thing with fonts and getting the actual cell's display width and calculating the width of the string version of the cell, etc.
The reason I want to do this is because I have a file that may be edited by many people, and I want to set it up to a standard setup from the workbook open function every time it's opened. I've already figured out how to select the proper sheet, unscroll to the top, and select a blank, innocuous cell.
Speaking of which, are there quick programatic answers to related questions:
- Get the display value of a cell vs. the formula therein
- Copy and paste a formula in relative or absolute manner
This message was edited by AChimpNamedCornelius on 2002-09-09 14:05