copy sheets of cell length is more than 255 char

I

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...
 
O

okaizawa

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble with 255 characters max in a cell 3
Get error message about copying cells with more than 255 characte. 2
Copy sheet with >255 chars per cell 4
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy sheet--Some cells more than 255 characters 2
Macro to Compile Data from Different Sheets 2
copying cells with more then 255 characters to new workbook 4
String data more than 200 characters in a cell 1

Top