View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Autofit Column Headers with wrapped text (Not a merged cell issue)

I have a macro in which the top row across many columns (the header row) is
selected and autofit. These cells are set for wrapped text.

Most of the columns work out well. However, a few columns drop a few
letters to the next line rather than space the column to fit the largest word.

Any idea how I can fix this? Again, I have selected the header row when I
apply the autofit. I do not have any merged cells (I know this can cause
problems).