copy sheets of cell length is more than 255 char
 

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
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=386044

copy sheets of cell length is more than 255 char
 

ok here is the solution....

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


:rolleyes:


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=386044

copy sheets of cell length is more than 255 char
 

Hi,

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

wsSource.UsedRange.Copy
wsNew.Range("A1").PasteSpecial

--
HTH
okaizawa

ilyaskazi wrote:
ok here is the solution....

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