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?

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.

"Dan Neely" wrote:

> 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?
>

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.

"Joel" wrote:

> 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.
>
> "Dan Neely" wrote:
>
> > 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?
> >

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")

Dan Neely wrote:
>
> 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?

--

Dave Peterson

Problem is fixed in Excel 2007

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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")
>
> Dan Neely wrote:
>>
>> 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?
>
> --
>
> Dave Peterson