in reply to Re^2: Problem seeing multiline text in Excel cells
in thread Problem seeing multiline text in Excel cells

Using the reccomended method of recording a VBA macro, I found that the following two lines
put the text to the top and left of the cell.
$sheet -> Range("B2:J2") -> {HorizontalAlignment} = xlHAlignLeft; $sheet -> Range("B2:J2") -> {VerticalAlignment} = xlTop
It still would be good to know how to make the height of the row to fit exaclty the height of however many lines of text there are.