Automatic row adjustment

[Haaksik]

Hi,

I have an issue with auto row height adjustment in Excel. The cell(s) to adjust contains a formula that points to data in another sheet of the same workbook. The formula returns text and depending on what is entered as data, it can be a short text or a longer one (the cell is also merged and wrap text is on).
Excel does not alter the row height according to the returned text. Maybe Excel is looking at the length of the formula (pretty short) rather then the returned data which is text.

Anyone that might be able to help? Thanks in advance.

 

[Smallman]

Hi @Haaksik

Nice Avatar pic by the way.

Deb Dalgleash has a blog post on the subject. It is an interesting read. There is a file at the base of the thread.

Autofit merged cells

Take care

Smallman

 

[Haaksik]

Hi Smallman,

Thanks, let me read it asap.

Btw: "haak-sik" is Cantonese for "black" .. hence the avatar.

 

[Smallman]

Hi Haaksik

That is one of the most amusing explanations for an avatars meaning. Gold. Thanks for sharing

Enjoy your read.

Oh - my last name is Small - hence my avatar.

Smallman

 

[bobhc]

@Smallman

Oh - my last name is Small - hence my avatar.

And heres me thinking it was because you were under five foot

 

[Haaksik]

Hi Haaksik

That is one of the most amusing explanations for an avatars meaning. Gold. Thanks for sharing

Enjoy your read.

Oh - my last name is Small - hence my avatar.

Smallman

Yup, saw your name on you site. Downloaded your file and VBA code. Will give it a shot today.

Good site btw, minimalistic layout what's gives it a clear overview. Unlike some other sites where you get a trillion ads in your face first before you get to what you're looking for...