Relative References Named Ranges

[cmore]

Hi, I am having trouble pushing a formula to cell and maintaining my exact relative reference; please help if possible. For some reason it keeps referring to U$12 rather than K$12. I'm not sure RefersToRange helps. Thanks for your help

Static NotesWfBalanceStart  = Sheet1!K$12

    Application.Goto Range(NotesWfBalanceStart)(2, 1)

    Names.Add "NotePayments", RefersTo:="=IFERROR(INDEX(" & TmpPmtFormulaRange & ",MATCH(" & NotesWfBalanceStart & "," & TmpPmtFormulaRangeHeader & ")),0)"

    Names("NotePayments").RefersToRange = Range(NotesWfBalanceStart)(2, 1)