Wrap text in Excel?

[abberration]

Hello, all.

I have been trying to figure out how to wrap text in Excel. I have been successful with resizing columns and such. I downloaded an Excel UDF that supposedly can resize columns, but didn't work.

Here's what I think should work. Does anyone know what is wrong?

$oExcel.Activesheet.Range("I:I").WrapText

[water]

Your code returns the current setting.

To set the property you need something like this:

$oExcel.Activesheet.Range("I:I").WrapText = True

[abberration]

You are the man, water! That works perfectly.

Thank you!

[water]