Replies

Hans,

Thank you for the code. I see what you mean about Excel not being good at text wrapping. There seems to a limit on the amount of text Excel can handle before it loses the ability to wrap text. I was trying to Merge cells in larger groups than I usually use. Using my usual method, which is breaking down the Merged cells into smaller groups. I’ve found that text either gets truncated or a line gets added when you print. What you see is not what you get. Larger cell mergers and auto fitting still do not solve the problem. I find that I still have to spend time Print Previewing and manually adjusting heights to get the print to look the way I want.

Excel is not a great tool for creation of forms featuring large text entries. But Excel is much better than Word at combining text form several different cells based on special criteria. I use many different blocks of text and combing them in different ways based on what I need the result to be. I know that Access is supposed to be the tool to use for what I’m doing but I have too much invested into my Excel forms to make the conversion at this point in my business life. Excel was there a long time before Access was.

Does anyone have a way for making the AutoFitMergeCells code work for a merged range that includes both multiple rows and multiple columns?

Thank You Jan. The transition key option was check and it is now the obvious source of the problem. That is not a menu I have ever played around with in the 15 plus years I have used Excel. I must have activated it accidently by pressing the wrong combination of keys. Hopefully this won’t happen to me again for at least another 15 years.

Thanks for the help Hans. The only thing that works is starting up Excel in safe mode. Nothing else seems to solve the problem. I even removed ancient add-ins that have work for years and that didn’t help. The only thing I can think of trying next is a reinstall of Excel to fix the problem.