Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Character Limits within an Array?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Character Limits within an Array?
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. "Max" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Character Limits within an Array?
Care to show the code?
Tim "Max" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining character limits | Excel Worksheet Functions | |||
Character Substitution in Array | Excel Discussion (Misc queries) | |||
character limits | Excel Programming | |||
Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
textbox character limits | Excel Programming |