View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geniusideas geniusideas is offline
external usenet poster
 
Posts: 70
Default How to make rows autofit when cells merge and multi line text inside

Hi,

In my project i need to fit row size accordingly, but the problem now
autofit not working when cells is merge and some-more inside this
cells contain multi line text (Next line with Alt+enter). Any one
here got idea how to do it? Most probably I need VBA code to do it.
Immediate reply much more appreciated.Thanks