Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autofit Merged Cells in Excel
I have tried to use Jim Rech's macro to autofit a merged cell in excel.
However, I cannot seem to get this to work for my situation. I have (1) row merged in (2) columns (D & E.) What am I doing wrong??? |
#2
|
|||
|
|||
There are three requirements and you mentioned 2. Is Wrap Text set for the
active cell? -- Jim Rech Excel MVP "kchambers" wrote in message ... |I have tried to use Jim Rech's macro to autofit a merged cell in excel. | However, I cannot seem to get this to work for my situation. I have (1) row | merged in (2) columns (D & E.) What am I doing wrong??? |
#3
|
|||
|
|||
Yes, I do have wrap text selected.
"Jim Rech" wrote: There are three requirements and you mentioned 2. Is Wrap Text set for the active cell? -- Jim Rech Excel MVP "kchambers" wrote in message ... |I have tried to use Jim Rech's macro to autofit a merged cell in excel. | However, I cannot seem to get this to work for my situation. I have (1) row | merged in (2) columns (D & E.) What am I doing wrong??? |
#4
|
|||
|
|||
You didn't specify exactly how it fails. Just in case the problem is that
the macro is not shrinking the row height, I should mention it is design only to increase row heights if needed. The reason being that there could be other merged cells on the same row that need the greater row height. Maybe you could copy/paste the problem merged cell into a new workbook and send it to me, once you verify that the problem reproduces in it of course.. -- Jim Rech Excel MVP "kchambers" wrote in message ... | Yes, I do have wrap text selected. | | "Jim Rech" wrote: | | There are three requirements and you mentioned 2. Is Wrap Text set for the | active cell? | | -- | Jim Rech | Excel MVP | "kchambers" wrote in message | ... | |I have tried to use Jim Rech's macro to autofit a merged cell in excel. | | However, I cannot seem to get this to work for my situation. I have (1) | row | | merged in (2) columns (D & E.) What am I doing wrong??? | | | |
#5
|
|||
|
|||
Jim,
The row height is not expanding to fit all the characters within the cell. I am not very familar with macros. I just started working on them last week. I don't mind sending you the workbook so you can look at it. How do I get your email address? "Jim Rech" wrote: You didn't specify exactly how it fails. Just in case the problem is that the macro is not shrinking the row height, I should mention it is design only to increase row heights if needed. The reason being that there could be other merged cells on the same row that need the greater row height. Maybe you could copy/paste the problem merged cell into a new workbook and send it to me, once you verify that the problem reproduces in it of course.. -- Jim Rech Excel MVP "kchambers" wrote in message ... | Yes, I do have wrap text selected. | | "Jim Rech" wrote: | | There are three requirements and you mentioned 2. Is Wrap Text set for the | active cell? | | -- | Jim Rech | Excel MVP | "kchambers" wrote in message | ... | |I have tried to use Jim Rech's macro to autofit a merged cell in excel. | | However, I cannot seem to get this to work for my situation. I have (1) | row | | merged in (2) columns (D & E.) What am I doing wrong??? | | | |
#6
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 - Selecting multiple cells from 2 different Pivot Tables | Excel Discussion (Misc queries) | |||
automatically fit an image into merged cells | Excel Discussion (Misc queries) | |||
How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
I need help getting Excel to auto-fill cells when I begin typing . | New Users to Excel |