Sendkeys methods to work for range

[Hertil]

Hi! This is my first thread on this forum, hope you understand me and help

I am working with excel for my personal project. I would to make a macro_button which changes formulas/text for hyperlink.
I have tried many options with sendkeys in macro but still have same problem. There are my codes I was trying:

Sub ConvertButton()
 Range("D3:D20").Application.SendKeys ("{F2}{F9}")
End Sub

and:

Sub SendKeys()
Range("D3").Select
Application.SendKeys ("{F2}{F9}")
Call SendKeys2
End Sub
Sub SendKeys2()
Range("D4").Select
Application.SendKeys ("{F2}{F9}")
End Sub
Sub SendKeys3()
[...]

Both codes have same problem, they change only one cell to hyperlink. In first case only "D3" cell is generate for hyperlink but second case generates only "D4" cell.
I would to make macro that change every cell in Range(D3:D20). Have you any ideas?

Glad you trying, thanks!