Trouble with 255 characters max in a cell

[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

 

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

 

[r]

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

regards
r

Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/index.php/Excel-VBA/UsedRange-eccezioni-e-alternative.html

 

[N1KO]

Thanks to you both, I'll see what happens.

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

regards
r

Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/index.php/Excel-VBA/UsedRange-eccezioni-e-alternative.html