All these posts have been extremely helpful in trying to understand why my
merged cell height doesn't work. I've used Jim Reich's macro to increase the
height of my cells, but, unfortunately am still having problems getting it to
work in some cells (but not others). I've searched posts trying to find an
answer but haven't been able to find it in any other thread.

Here it is: my input document contains many comment boxes which vary in
(merged) size from 5 to 12 columns (this was done more for aesthetics than
anything else). When I run the macro, I get a Runtime 1004 error (Unable to
set the ColumnWidth property of the Range Class) OR (Unable to set the
MergeCell property of the Range Class) . If I click on debug, the
highlighted line shows on .Cells(1).ColumnWidth = AcitiveCellWidth (in the
first case) and on .MergeCells = False (in the second case). When I get back
to my spreadsheet, the first column has expanded to fit all the text (it
appears to be ignoring the merge feature). I do have "merge cells" and "wrap
text" clicked in each of these boxes.

I'll be the first to admit that I know next to nothing about macros, but I
can usually figure out my problem, but this has me completely stumped. Any
and all help will be greatly appreciated!