Trouble with 255 characters max in a cell

N

N1KO

Hi,

I'm having an issue with moving/copying sheets into a new worksheet as some
of the cells contain more that 255 characters.

Is there anyway around this problem?

Any help is appreciated.

Thanks in advance
 
D

Dave Peterson

Moving shouldn't cause any trouble. But copying will.

I use multiple steps.

Copy the sheet
Copy the cells on the original sheet
paste on the new sheet

Same thing in code, too.
 

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

copy sheets of cell length is more than 255 char 2
VBA formula strings longer than 255 characters 3
Copy sheet with >255 chars per cell 4
copying cells with more then 255 characters to new workbook 4
Copy sheet--Some cells more than 255 characters 2
Word wrap with > 255 characters 2
255 characters problem 1
Autofilter over 255 characters in a cell? 5

Top