String data more than 200 characters in a cell

[Varun]

I have an excel sheet with data that contains string more than 2000 characters.

When I was trying to copy the whole sheet data to a new excel filw using
VBScript, the data is getting truncated to 255 .

I would like to know a wayout on how to copy the data from one excel sheet
to another if a cell contains data of length more than 2000 characters using
VBScript ?

 

[Jan Karel Pieterse]

Hi Varun,

I would like to know a wayout on how to copy the data from one excel sheet
to another if a cell contains data of length more than 2000 characters using
VBScript ?

You need to copy the cells from the source to the target worksheet.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com