Excel Cell (Range) Not Allowing Multiline Text ??????

O

OHDev

Hello there ...

I'm Using the Microsoft Office SpreadSheet Object or in other words the
Excel Spreadsheet Object in Visual Basic 2005

The Problem I'm facing is that I can't put a Multiline String into A Cell
when I do that it ignores the Line feedbacks

whether i send it with VbNewline or with Chr(10)
and there is No property called WrapText although it Exists in VBA

so i can't find any Property/Method in the cell (Range) Object that Allows
me to have a Multiline cell.

Does anyone know a Solution to this ?
If not what are the Possible Work-Arrounds ?
Thank you very Much!
OHDev
 
B

Big Daddy

Excel doesnt have a multiline, set the .WrapText = True on selection or
range
 
O

OHDev

"and there is No property called WrapText although it Exists in VBA"

Thank you for your Reply :) ... but I already Mentioned that the Wraptext
Property doesn't Exist.
Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top