Among others, I'm having some trouble getting Jim Rech's code to
Autofit Row height in merged cells to work the way I want it to.
Is there a simple worksheet event code I could
use to Autofit Row in
four cells, preferably upon recalculation?
Specifically, A:N are merges in four different rows, 23, 47, 68, and
The width of column Column Z is is the same as A:N combined
Z23 is =A23
Z47 is =A27
Autofit doesn't automatically work in Z23 because of the formula, in
fact, F2 Enter doesn't even work. I have to paste values or select the
cells and Alt O R A.
I should figure this out myself, getting VBA for morons this weekend,
but if someone would help with this one I'd appreciate it.