Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Bernie, sent me a macro (Jim macro) that automatically sets the row height
based on text length, given the column width. The works well. Unfortunately I have to select the merged cells one by one and run the macro. It takes a long time as I have about 20 groups of 3 rows with 4 murged cells in each row. If I select more than one cell the macro doesn't work. So the question is how to tell the macro to select all the murged cells and have the height set. I can easely select all the rows with murged cells with a macro but how connect with Jim's VBA macro? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) | |||
Rows with merged cells are not adjusting even w/ Wrap Text and au. | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
How do I get merged cells to display all text. | Excel Discussion (Misc queries) | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |