Forum

I figured it out. The spaces in one of the names were Code 160 instead of Code 32. I ran a macro to change the Code 160's to 32's.

Thank you Riny. What do you mean by "ranges transformed to structured tables?" In the "By Position" tab, I used tables. The stuff in Shee...

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(...