text wrap w/ merged cells

[Guest]

I have 3 column that are merged cells that I would like to text wrap. I
understand that Excel has a problem doing this, but is there some sort of
formatting I can to make it automaticaly adjust my row height. If there is
then please let me know. Normally I would just do it manually but there are
some formulas I don't want screwed up and other people will be entering data
so I want to protect my worksheet.....Thanks in advance for any help or
attempted help.
Travis

 

[JE McGimpsey]

No, there's no formatting that will adjust row-height on merged, wrapped
cells. If you look in the archives, you'll find a macro by Jim Rech that
will do this for you.

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

 

[Guest]

I copy and pasted the macro code but it doesn't work. I'm not at all familiar
with macros. Can you maybe give me a quick step by step on how to go about
it?. Thanks in advance.

 

[JE McGimpsey]

See David McRitchie's "Getting Started with Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm