VBA Can't Insert Long String Into Excel Cell

[Mav3000]

Hi All,

I've a function that opens an Excel Object and worksheet, and then attempts to put a variable's content into a cell.

When the variable (which is a String) has more than 256 characters in it, Excel refuses to insert it into the cell and gives a Error 1004 Application-defined or object-defined error.

The function works fine is a shorter string is passed.

How can I overcome this? One string is 908 characters in length.

Any help appreciated,

Mav3000

 

[HughLerwill]

Did you see this

http://support.microsoft.com/kb/213841

 

[Mav3000]

Hi Hugh,

I didn't see that article, despite Googling for the answer and reading several other pages. Thanks for link that explains the work around really well.