Forum

Thank you Alan. I have attached my current spreadsheet. I am using Office 365. I have a section commented out that does not work. Once...

You're correct. It did work like that already. I have a new problem. I've added a Boolean argument to the function. Public Function Annuity(...

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!