As I'm new here, Hi everyone!

I'm having a problem when I try to copy the content of a tex
containing cell to the clipboard.
Everytime the number of characters in the cell exceeds 1024 (1kb) ,
get the following error when running the copy-macro:
run-time error '1004': Application-defined or object-defined error.

The code I use for copying is the following:

Dim MyData As DataObject
Dim MyString As String

Set MyData = New DataObject

MyString = Range("B36").Formula

MyData.SetText MyString
MyData.PutInClipboard


Does anyone know how to overcome that limitation?

thanx in advanc

--
Message posted from http://www.ExcelForum.com