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

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" <(E-Mail Removed)> wrote in message
news:adddc14a-6637-413d-bfb1-(E-Mail Removed)...
> 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