auto fit-wrap texted merged cells

[Wandering Mage]

I am trying to auto fit merged cells with wrapped text
(auto fit the row of merged columns). However, this does
not work. It isn't just the macro either, I can't do this
just in excel, which I never realized. Does anyone know
if there is any way around this? Let me know. Thanks!

 

[Frank Kabel]

Hi
AFAIK no way around this as this is one of the problems with merged
cell (therefore nearly all would recommend NOT to use merged cell at
all!)

 

[Norman Jones]

Hi Wandering Mage,

Jim Rech posted the following a routine to handle this:

http://tinyurl.com/4c5l6


___
Regards,
Norman

 

[Wassim]

Hello "Wandering Mage"

Must you use Merged Cells?

I dislike this feature in MS-Excel and try to avoide it by all means.

Sorry this might not solve your problem, butI think having multiple
opinions may help.

Wassim