Here's an odd question. I have a macro that reads the contents of a column
into an array. The size of the cell contents can vary, and sometimes exceeds
255 characters. Sometimes, the array data is truncated to 255 characters,
other times it is not.

1) Why?
2) Is there a way to eliminate this phenomenon?

--
Thanks!
Max