View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Trouble with 255 characters max in a cell

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.

N1KO wrote:

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


--

Dave Peterson