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