String data more than 200 characters in a cell

V

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 ?
 
J

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 ?
Click to expand...

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
 
Top