copy sheets of cell length is more than 255 char

[ilyaskazi]

In my workbook cell containing data length is more than 255 characters.

When I export its sheets to new workbook it gives me msgbox saying:

"The sheet you are copying has cells that contain more than 255
characters. When you copy the entire sheet, only the first 255
characters in each cell are copied. To copy all of the characters,
copy the cells to a new sheet instead of copying the entire sheet."

I am exporting sheets through vba. With this type of automation it is
not possible for me to find the length and copy the cells instead of
copying entire sheet.

I need some way out to copy all the required data if containing more
than 255 characters with option of exporting entire sheet.

Its urgent, please help...

 

[ilyaskazi]

ok here is the solution....

http://www.pcreview.co.uk/forums/thread-1739316.php

 

[okaizawa]

Hi,

extra information:
you should note that UsedRange doesn't always start A1.
wsSource.Cells.Copy works as well.