I also changed the first line to: Public Function Annuity(age, defAge, ArrayMortality As Variant, Seg_1, Seg_2, Seg_3) In the spreadsheet attach...
I took out the () after ArraryMortality and it still does not work. The function worked when I input all variables except the mortality table. I n...
What do you mean by, "the code is not fully qualified?" I want this code to work on any worksheet in the workbook. Ideally, I would like it to l...
The range did return Booleans. My problem was that some of them were blank. I fixed it. Thank you for you help.
Hi Mynda, I am able to get the mortality table into Excel. I had to get help from this forum to reference the array values. I now want to man...
Thank you Purfleet. This works!
I want to populate cells B5 through B125 on tab "Q's etc" The values should come from the named array selected in cell B2 on the "assumptions" tab. ...
I hope this upload worked.