Character Limits within an Array?

[Guest]

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?

 

[Guest]

I know that the display on the worksheet is truncated if there is data in the
adjacent cells, whether that data is visible or not. However, if your
records are being truncated in the array variable, I don't have an answer for
that.

 

[Tim Williams]

Care to show the code?

Tim