View Single Post
  #2  
Old February 12th, 2004, 09:54 PM
Popandopolo
external usenet poster
 
Posts: n/a
Default macro: merge, wrap text, left justify and auto-fit

Hi,

Rows("1:1").RowHeight = 25

Cheers,
Pyzatiy Popandopolo

-----Original Message-----
I am trying to write an excel macro that merges 4 cells

in
4 columns, wraps the text, left justifies and adjusts the
row height so that all of the text is visible. I can get
everything to work but the adjusting of the row height.
The row height always adjusts to the default setting.
What is the fix?

Thanks,

John Ammon

.