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
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