| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.Copy() truncates cell contents problem
I have written a macro which copies a worksheet and then alters some
of the values in the copied sheet. Everything works fine except that any text cells with more than 255 characters are truncated. Is there a way I can stop excel doing this? TIA Mark. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet.Copy() truncates cell contents problem
Maximum column width up through Excel 2003 is 255 characters.
"Mark Hanley" wrote: I have written a macro which copies a worksheet and then alters some of the values in the copied sheet. Everything works fine except that any text cells with more than 255 characters are truncated. Is there a way I can stop excel doing this? TIA Mark. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet.Copy() truncates cell contents problem
1. Do the worksheet copy first
2. have the macro go back to the original sheet and look for text cells containing more than 255 characters and copy them individually -- Gary''s Student - gsnu200725 "Mark Hanley" wrote: I have written a macro which copies a worksheet and then alters some of the values in the copied sheet. Everything works fine except that any text cells with more than 255 characters are truncated. Is there a way I can stop excel doing this? TIA Mark. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet.Copy() truncates cell contents problem
You can do this
After you copy the whole sheet Copy all cells from the source sheet and copy it in the new sheet sheets("sheet1").cells.copy destsheet.cells(1) If you not care about the settings of the sheet settings You can insert a new sheet and copy all cells in this new sheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Hanley" wrote in message ups.com... I have written a macro which copies a worksheet and then alters some of the values in the copied sheet. Everything works fine except that any text cells with more than 255 characters are truncated. Is there a way I can stop excel doing this? TIA Mark. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing truncates cell contents | Excel Discussion (Misc queries) | |||
| Formulas to copy contents of one cell in a worksheet to another ce | Excel Discussion (Misc queries) | |||
| worksheet.copy truncates at 255 characters | Excel Programming | |||
| how to copy cell contents from one workseet to another worksheet? | Excel Discussion (Misc queries) | |||
| Copy cell contents to another worksheet | Excel Programming | |||
Linear Mode
