Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit Row Height with Merged Cells in the Row
I need to add text from a Userform Textbox to a worksheet. Sometimes the
textbox may conatin a few sentences. Unfortunately, the text needs to span across 3 Columns. I would like my code to put the textbox text into the merged cells, wrap the text to fit, and automatically adjust the row height. Is it possible to do this or is there an easier way? The text has to be contained between Col.C and Col.E. Sub AutoFitText() With ActiveCell 'ActiveCell = Range("B10") in this case '.....I have additional code here .Offset(30, 1).Value = " €¢ Comments: " & tbxComments With Range(.Offset(30, 1), .Offset(30, 3)) .Merge .HorizontalAlignment = xlLeft .VerticalAlignment = xlCenter .WrapText = True .Rows.EntireRow.AutoFit End With '.....I have additional code here as well End With Thanks in Advance, Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merged cells won't Autofit row height | Excel Discussion (Misc queries) | |||
Row height using autofit, with no merged cells | Excel Discussion (Misc queries) | |||
Autofit Row Height of Merged Cells | Excel Discussion (Misc queries) | |||
Autofit row height in merged cells | Excel Discussion (Misc queries) | |||
Autofit of Row Height with Merged Cells - AGAIN! | Excel Programming |