When I am try to increase the array size more than 5 and passing the cash flow values to IRR function, it is throwing an exception.
example
Dim values(6) AsDouble
' Business start-up costs.
values(0) = -70000
' Positive cash flows reflecting income for four successive years.
values(1) = 22000
values(2) = 25000
values(3) = 28000
values(4) = 31000
values(5) = 33000
And passing this array to IRR function throws exception. Is this known bug?