Character Limits within an Array?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Max - 20 Sep 2007 12:36 GMT

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?

Signature

Thanks!
Max

Reply to this Message

JLGWhiz - 20 Sep 2007 13:18 GMT

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.

> 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
[quoted text clipped - 3 lines]
> 1) Why?
> 2) Is there a way to eliminate this phenomenon?

Reply to this Message

Tim Williams - 20 Sep 2007 17:45 GMT

Care to show the code?

Tim

> Here's an odd question. I have a macro that reads the contents of a
> column
[quoted text clipped - 5 lines]
> 1) Why?
> 2) Is there a way to eliminate this phenomenon?

Reply to this Message