I figured it out for myself! I selected the Group Box. Holding the control key, I then selected each button. Then I did copy/paste. (Ctrl-V) I...
I was trying to sum the values of ArrayPresentValueSum by looping through it. I discovered WorksheetFunction.Sum and switched to that. Now it work...
Duh on me. I thought I had checked all of those.
Thank you. This is what I needed.
I added the file.
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...