I'm trying to make a macro where I can insert a formula with both relative and absolute referencing (e.g. =F$58+F59). The thing is, I want the absolute value to be based off of where I started the macro so that I can then use the pull down function to automatically fill in the rest of the values. For example, if I started in A6, I want the formula to say something like =F$6 + G6 and when I pull it down and if I started in A7, I would get =F$7 + G7.

I was thinking this should be a two step process:
1. "=RC[1]+RC[2]"
2. somehow make only the second absolute reference.

I know I can convert the whole formula to absolutes with a macro, but I'm not sure if I can iterate over the whole formula e.g. just change the first and third references to absolute, but leave the second reference as relative.

I was looking at the following for inspiration (which doesn't work in this form), but gave me a general idea:
Sub Macro19()
'
' Macro19 Macro
'
Dim RdoRange As Range
Dim i As Integer
Dim Reply As String

'Relative row/Absolute column

For i = 1 To RdoRange.Areas.Count
RdoRange.Areas(i).Formula = _
Application.ConvertFormula _
(Formula:=RdoRange.Areas(i).Formula, _
FromReferenceStyle:=xlA1, _
ToReferenceStyle:=xlA1, ToAbsolute:=xlRelRowAbsColumn)
Next i


'Clear memory
Set RdoRange = Nothing
End Sub

Thanks for any help, it would be greatly appreciated!