Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merged Cell Height
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
Auto fit merged cells | Excel Discussion (Misc queries) |