View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Left justify across cells with word-wrap without merge

Hi Sean
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

Sean Bartleet wrote:
Hi,

Is it possible to left justify across several cells in a row with
word-wrap on, similar to the "centre across selection" justification
option. I know that you can achieve this by merging the cells. One of
the problems I have with merging the cells is that the row height

does
not automatically adjust to accommodate the text. The other problems

I
have with merge are too numerous to mention, suffice it to say that I
believe that this feature should be declared illegal or at the least
banished.

Is it possible to do this programmatically?

I am using Excel 2002

Any assistance will be appreciated.

Thanks

Sean Bartleet