Hyperlink Through VBA

[Faiek]

I Have this code to create a hyperlink through VBA:

Range("F23").Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
        "", TextToDisplay:="Drawing Link"

Is there a way to make the address of this new hyperlink the same address of a hyperlink on another cell dynamically? Like by incorarating VLOOKUP Or Indexing?

Thanks,
Faiek