Hi. Need assistance fine-tuning Greg Wilson's (or Jim
Rech's)code re autofit row height for merged cells. I'm
pretty much still at the "copy and paste" programming
level.
Two problems:
1. Using Greg Wilson's "selection change event", user must
hit enter to exit the merged cell, then re-enter the
merged cell before the auto fit will occur. Is there any
way to have this happen when user first exits the cell
(likely using "enter").
2. Is there any way to shorten the code to integrate all
10 separate rows of merged cells (regular rows are in
between the various merged cell rows), rather than just
copying the same code over and over and changing the row
references?