| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofit rowheight after auto change line
i'd like to have a macro to auto set the best fit row
height after setting auto line change (justify). I tried "selection.row.autofit" but it just return the row height that fit the 1st line in the cell only. Possible just referenced to the font size only. Could experts pls help. Tks. macro beginner |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofit rowheight after auto change line
Selection.EntireRow.Autofit
-- Regards, Tom Ogilvy "RC" wrote in message ... i'd like to have a macro to auto set the best fit row height after setting auto line change (justify). I tried "selection.row.autofit" but it just return the row height that fit the 1st line in the cell only. Possible just referenced to the font size only. Could experts pls help. Tks. macro beginner |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is RowHeight=0 the same as Hidden | Excel Discussion (Misc queries) | |||
| Find 4.75 and Replace with 12.75 ( Rowheight ) | Excel Discussion (Misc queries) | |||
| why does line not autofit to amount of text? | Excel Discussion (Misc queries) | |||
| auto change line | Excel Discussion (Misc queries) | |||
![RC[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
