Using OLE Automation and Excel 2000, I am loading memo fields into cells of a sheet. The text will go into the cell, but if the text length > 255, the formatting does weird stuff. I have the column set to wrap text, and it will not do it for these cells. I found that 255 chars was a limitation in earlier versions of Excel, but that is no longer the case.

Now to muddy the water a bit :)

You can enter text manually greater than 255 length and the wrapping has no trouble.

You can paste into a cell from the clipboard, and there is no problem

I have tried setting the value through Automation, and also pasting from the clipboard, byt assigning _CLIPTEXT to the memo content and pasting it in in the sheet using the Paste() method.

Setting the value (mysheet.activecell.Value = cMemoText) puts the data into the cell, but the text won't wrap if it is longer than 255.

Pasting in from the clipboard has the same problem, and it destroys the formatting of the column width at the same time.

Help!

Jim