I created a function that works.
I then copied it and added some more variables. The function does not get past reading in the variables.
Here is the beginning of the code.
==============================
Public Function AnnuityJS(age, spage, defAge, MortTblName As Integer, SpMorTblName As Integer, JSPct As Variant, Seg_1 As Variant, Seg_2 As Variant, Seg_3 As Variant, IntOnlyDef As Boolean)
Debug.Print age
Debug.Print spage
Debug.Print defAge
Debug.Print MortTblName
Debug.Print SpMortTblName
Debug.Print JSPct
=========================
Debug print will show the variable listed except for SpMorTblName.
Your input variable is called SpMorTblName, not SpMortTblName
Duh on me.
I thought I had checked all of those.
Option Explicit is your friend. 😉