Recent content by vin4559

TO PHV- Yes, #value appeared in the cells of the spreadsheet array. Since Excell's error checking provided the advice that the error was a result of a wrong data type, it wasn't obvious (though it should have been to me, as you have shown) that there was a division by zero producing the #value...

Thanks for that common sense. The question is answered but for one thing: stepping through the function with the debugger never produced the divide by zero error. I wonder why not?

Thanks to PHV for responding. The function and others like it work except in this one case, so the answer does not solve the problem, which is the unique #VALUE response. Thanks for any help.... but I'll go away if you guys think this is too elementary.....

I am calculating values in a spreadsheet array using two variables that are the margins of the array and two variables that are fixed outside the array. Each cell calls a macro function: =femalefitness04Small.xls!WNDf.WNDf($P$3,$P$4,$B4,C$3) The function code is: Option Explicit Function...