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
|