Mixed absolue & relative formula through vba

[TryingToLearn]

My project has many named ranges and I'm creating formulas in various cells based on their addresses. The issue is these evaluate to absolute formulas where I need mixed. Is there any way to accomplish this?
example:

tgtF = "=" & Range(Cells(Target.Row, _
    Range("runbal").Column).Address).Address & "+" & "Sum(" & OutRng.Address & ")"

evaluates to: =$G$149+SUM($I$135:$I$149)
Then:

tgtF.Formula = Application.ConvertFormula(tgtF.Formula, xlA1, xlA1, xlRelative)

results in: =G149+SUM(I135:I149)

Is there any way through VBA I can end up with: =G149+SUM(I$135:I149)

 

[footoo]

.

 

[footoo]

tgtF.Formula = "=" & Cells(Target.Row, Range("runbal").Column).Address(0, 0) & "+" & "Sum(" & OutRng(1).Address(1, 0) & ":" & OutRng(OutRng.Cells.Count).Address(0, 0) & ")"

 

[TryingToLearn]

tgtF.Formula = "=" & Cells(Target.Row, Range("runbal").Column).Address(0, 0) & "+" & "Sum(" & OutRng(1).Address(1, 0) & ":" & OutRng(OutRng.Cells.Count).Address(0, 0) & ")"

The simple things we don't know to even look for!!! Thank you, thank you!