Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 70 The width of column Column Z is is the same as A:N combined Z23 is =A23 Z47 is =A27 etc. 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. Application.Goto Reference:="Z23,Z47,Z68,Z70" Selection.Rows.AutoFit |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofit for row height is not working. Why? | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Autofit row height in merged cells | Excel Discussion (Misc queries) |