marsulein,
How do you DIMension "strTemp" ?
And how are trying to set its value ?

NickHK


"marsulein" wrote in message
...

Hi All,

I create an excel object in VB and store the data from the spreadsheet
into a local variable called strTemp. However, error occurs when the
data field is larger than 255 characters. Excel automatically truncate
the data to 255 chars and gives out error:

"Arguments are of the wrong type, are out of acceptable range, or are
in conflict with one another"

Is there anyway to fix this?

Thanx in advance.

Regards,
Mar


--
marsulein
------------------------------------------------------------------------
marsulein's Profile:
http://www.excelforum.com/member.php...o&userid=16064
View this thread: http://www.excelforum.com/showthread...hreadid=275204