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

Sub test()
ActiveSheet.Cells.Copy
Worksheets.Add.Paste
End Sub

regards
r

Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/...ternative.html


"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

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