Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array formulas cannot return strings longer than 255
Array functions, even in Excel 2007, seem to be limited to returning
strings shorter than 255 characters. To see this, enter the following function as an array formula: Public Function HOHO() As Variant Dim v As Variant ReDim v(2, 2) v(0, 1) = "HOHO" v(1, 1) = String(256, "a") HOHO = v End Function Is there any way around this error? Thanks, Alok |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array formulas cannot return strings longer than 255
Pretty sure I recall seeing this "limitation" documented in an MS KB
article. Need to workaround, at the very least truncate any 255+ strings in a array returned to a UDF. Perhaps place the excess into additional element(s) of the array. Regards, Peter T "Alok" wrote in message ... Array functions, even in Excel 2007, seem to be limited to returning strings shorter than 255 characters. To see this, enter the following function as an array formula: Public Function HOHO() As Variant Dim v As Variant ReDim v(2, 2) v(0, 1) = "HOHO" v(1, 1) = String(256, "a") HOHO = v End Function Is there any way around this error? Thanks, Alok |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
Excel - formulas to no longer calculate. | Excel Discussion (Misc queries) | |||
Formulas no longer working | Excel Worksheet Functions | |||
Can I upgrade Excel to allow longer formulas? | Excel Programming | |||
formulas are no longer calculating...what can I do? | Excel Worksheet Functions |