Copy sheet with >255 chars per cell

[Dan Neely]

Excels sheet copy feature is limited to copying the first 255
characters in a cell. Could a macro be used to copy the sheet along
with characters 256+, and if so, how would it be written?

 

[Joel]

The copy function will copy more than 255 character, it just doesn't display
over the 255 characters. I belive the limit for the number of characters in
the cell is 16,000 characters. The problem is you can't see all 16,000
characters. The visible portions of the string is liomited to 256.

 

[JLGWhiz]

For accurate details on specifications and limits, type:

Excel specifications and limits

in the Excel Help search box and select that option from the menu.

 

[Dave Peterson]

If you're doing this manually, you can copy the sheet, then go back and copy the
cells on the original sheet and paste onto the new sheet. Then those long
strings in the cells will get copied over.

This may give you an idea in code:

Dim wks1 As Worksheet
Dim wks2 As Worksheet

Set wks1 = Worksheets("sheet1")

wks1.Copy 'to a new workbook?
Set wks2 = ActiveSheet

wks1.Cells.Copy _
Destination:=wks2.Range("a1")

 

[Ron de Bruin]

Problem is fixed in Excel 2007