[RESOLVED] WordWrap In Excel

[Hack]

I have the following lines of code in VB6

shWorkSheet.Range("A29") = "Comments"
        shWorkSheet.Columns("A:BZ").AutoFit
        bkWorkBook.Worksheets(1).Columns(30).WrapText = True
        shWorkSheet.Range("A30") = txtComments.Text
        bkWorkBook.Worksheets(1).Columns(30).ColumnWidth = 12

txtComments is a multiline text box and I need to display the contents in an Excel spreadsheet as a block of text.

Right now, the comments are all in row 30 and spreading across in a single line to about column I or J.

What modifications do I need to make?