Excel – Copying more than 255 characters!

Hi,

I am doing a daily synchronisation(copying from source to destination) of 2 excel files using VBA code.But I recently noticed that cells having more than 255 char in the source file are truncated in the destination files. Is there any solution for this?