Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solution To Auto Height For Merged Cells
If anyone is interested, I found a way to automatically adjust a row height based on merged cells text. Here's how I did it... In a cell unmerged and on the same row as the merged cells, enter the formula = merged cells and set the formula cell to the same column width as the combined merged cells. For example: Merged cells are B2:D2, formula in F2 is "=B2". Then set column F width to match merged cells. So if the merged cells combined column width is 30, set column F width 30. Then in the worksheet VBA, use this code. This will automatically adjust the row height after the text in cell B2 is entered. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 2 Then ActiveSheet.Rows(2).AutoFit End If End Sub Happy VBAing. -- JoJo ------------------------------------------------------------------------ JoJo's Profile: http://www.excelforum.com/member.php...o&userid=11307 View this thread: http://www.excelforum.com/showthread...hreadid=572423 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Row Height with Wrapped Text in Merged Cells Problem | Excel Discussion (Misc queries) | |||
How to enable auto height with merged cells? | Excel Worksheet Functions | |||
Auto Row Height in Merged Cells with pre exisiting text | Excel Worksheet Functions | |||
Can word wrap and merged cells auto row height properly in Excel | Excel Discussion (Misc queries) | |||
Auto Row Height for Merged Cells | Excel Programming |