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

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