Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adjust Row height to FONT
I am building a spreadsheet thru code.
Is there a way to determine what the row height should be when I change a FONT and FONT Size? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adjust Row height to FONT
Rows("4:4").EntireRow.AutoFit
NickHK "Joe" hx.gbl... I am building a spreadsheet thru code. Is there a way to determine what the row height should be when I change a FONT and FONT Size? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adjust Row height to FONT
Or even get all the rows at once...
with worksheets("sheet9999") .rows.autofit end with Joe wrote: I am building a spreadsheet thru code. Is there a way to determine what the row height should be when I change a FONT and FONT Size? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adjust cell height | Excel Discussion (Misc queries) | |||
Automatic row height adjust | Setting up and Configuration of Excel | |||
Adjust row height automatically | Excel Discussion (Misc queries) | |||
How do I adjust row height to set cell margins to zero? | Excel Discussion (Misc queries) | |||
HOW DO I ADJUST ROW HEIGHT BY PIXEL? | Setting up and Configuration of Excel |