Macro to change only part of a formula to absolute

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!

That seems to work fairly well. I think I understand the function you provided and have been manipulating it to fit my actual formula. One final question though, can the row be changed to two higher? So if the active cell is F6, how would I get it to give me F$2? Something like:

Please Login or Register  to view this content.

(This doesn't work of course). Thanks!

Yeah I was just playing around with it and found that. Before I was using brackets, which it didn't like :p Thanks again!