Autofit Merged Cells? Can we do this?

[kenji4861]

I have a row that has merged column cells. Even if I choose autofit, it
will not autofit. Is tehre a way to do this?

 

[J.E. McGimpsey]

If you search the group archives:

http://google.com/advanced_group_search?q=group:*excel*

using "merge autofit" (without quotes) as search terms, you'll find
many posts on this topic, including links to a macro by Jim Rech
that may work for you.

 

[Dave Peterson]

Here's a macro written by Jim Rech:

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[kenji4861]

Where or when do I have this function/procedure called? As soon as
theres a change in the sheet? I just have a sub function/procedure
sitting in my macro module.. but when is it executed? Thanks

 

[Dave Peterson]

Jim's code runs against the activecell.

So when you have your merged cell selected, hit alt-F8 and run that macro.

 

[kenji4861]

this will work if each line has a few texts.. but when text becomes a
paragraph, it does not work.

The text gets cut off. Why is this?

 

[Dave Peterson]

Sometimes if you sprinkle a few alt-enters to force a new line within the cell,
you can see more of the text.