I'm so thankful for Jim Rech's code* (and those who directed me to it) that allows auto-expansion of merged cells, but I have
a shared workbook with at least 10 sheets, each of which has more than 40 different merged cells that may need
auto-expansion. Because there are so many merged cells, not to mention Excel-phobic users typing into them, I want to avoid
personally running this macro for each cell that needs expansion. Unfortunately, my very rudimentary VBA skills are of no
Given that, I have several questions:
Can I have the macro run automatically for each sheet, checking all the merged cells (or simply all cells), when the user
saves or exits?
Can I have the macro check every single cell in the workbook? I'd like to run this version manually.
Can the macro activation event be when the user has finished entering text and moves to a new cell whether
bytabbing,hitting enter, orclicking on the next cell they want to modify?If so, does anyone know how expensive this would be
in terms of time and memory? All my users are accessing the workbook remotely and already have a good deal of lag due to
*Jim Rech's AutoFitMergedCellRowHeight Code