Row Height

[sushantrao]

I have more than 256 characters in one cell.Object is veiw all contents in cell.I tried auto height for row but it is not working.
Is there any other method for auto row height. I want to give auto fit hight for row through code.can any one provide code.

 

[VoG]

Something like this should work

ActiveCell.WrapText = True

 

[riaz]

Hi Sushant

Have a look at this thread. It sounds like your problem. If you choose row height autofit based on the cells outside your print area, it will force the row height in your print area to expand accordingly.

http://www.mrexcel.com/forum/showthread.php?t=328878

Regards