Array formulas cannot return strings longer than 255

A

Alok

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
 
P

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF Can't return more than 255 chars??? 3
Using a UDF within SUMPRODUCT 10
Relative Referencing Formulas in Arrays 1
VBA formula strings longer than 255 characters 3
array output to cell range 5
Limitation of PivotCache.CommandText property 4
UDF Not Returning Array to Range 6
Can I SPLIT into bigger array elements 2

Top