View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Gummer Peter Gummer is offline
external usenet poster
 
Posts: 3
Default Range WrapText and AutoFit with Bold

Dave Peterson wrote:

Did you use alt-enter to force new lines in the cell--where you
wanted the lines to break?


No, I don't want to do that. I'm loading data programmatically. The
column headings will be different every time.

Then I use format|column|width|255 and hit enter
then format|column|autofit


I can do that programmatically, but then the columns are too wide. I
want the text to wrap without breaking words in the middle, widening
the columns just enough to fit whole words but not the whole text.

Thanks for the suggestions.

-- Peter Gummer