Forum

This works very well. How would I do the following?: Replace the cell reference with a number. The number would reference a multi-column and ...

With my current code, this function works. =Annuity(N5,N6,GAM83Male,N2,N3,N4) I want this to work. =Annuity(N5,N6,T8,N2,N3,N4) ...

Here is my current code that works. Public Function Annuity(age, defAge, ArrayMortality, Seg_1, Seg_2, Seg_3) Dim ArrayL(122) As Variant Dim A...

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.