View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
fostertom fostertom is offline
external usenet poster
 
Posts: 2
Default FormatRowAutofit

Hi

in Excel 2003, I have a 380row x 2col sheet, all text, no functions so far.
Text was imported from Word, other Excels etc. Up to 10 lines of text in some
cells, word-wrapped, many new-line (Alt + Enter) breaks. No merged cells.

Problem is, FormatRowAutofit is unreliable. For 90% of cells works fine
but some either show white space between text lines, or shrink too much,
cutting off last text line(s). If adjusted manually, seems unstable - will
revert for no reason.