autorow height

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set the row height using Selection.Rows.AutoFit but it does
not seem to be working when there are merged cells.

Any help is appreciated.
 
There are two basic ways to deal with the AutoFit problem with merged cells:
1) Have a single cell in the same row offscreen that is sized the same as
the merged range that has a formula that refereces the value of the active
cell of the merged range. Therefore, this cell always holds the same value as
that entered in the merged range. Use the Worksheet SelectionChange event to
force AutoFit of this cell. Since it is in the same row as the merged range,
it fixes the problem.
2) Use more complex code fired by the SelectionChange event to effect the
AutoFit.

Regards,
Greg
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using row autofit but with minimum height 4
AutoFit macro that will not affect the header row? 2
More Useful Row Autofit 1
Row Height 2
AutoFit Macro to Reduce row height? 0
Excel VBA For excel 0
Auto fit wrapped and merged cells in entire worksheet Options 0
VBA set thick borders around non empty cells in range 0

Back
Top