Thanks Microchip. You can see from the code (posted against Mike) that I
don;t use any variables but perhaps i need to!

Martin

"Microchip" <Microchip@discussions.microsoft.com> wrote in message
news:79DEAA95-B6DD-41F9-9EE1-D25A3A6D92FC@microsoft.com...
>I was getting the same problem. Check your variable declarations carry the
> correct types. E.g. Byte 0-255, Integer -32,768 to 32,767, Single, Double
> etc.
>
>
>
> "Martin Walke" wrote:
>
>> Hi all,
>>
>> Can anyone tell me if there's a limit to the size of data that you can
>> insert into an excel cell using VB6 automation? I'm transferring data
>> into a
>> worksheet but whenever the data is more than about 1000 bytes I get an
>> automation error 1004 "Application-defined or object-defined error"...
>> but
>> if I manually paste the same data into the cell, there's no problem.
>>
>> The data is coming straight from an access 97 database.
>>
>> Any ideas?
>>
>> TIA
>> Martin
>>
>>
>>
>>
>>