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.