Add Hyperlink to every cell in range

[sharky12345]

Is there a way I can automate adding a Hyperlink to every cell in my range which goes down to row 1930?

I've used a Macro recorder to do the first one but manually doing this for every cell would be really time consuming:

    Range("A2").Select    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
        "MASTERLIST!A2", TextToDisplay:="SD001"

I want the links to apply in every cell between A2:A1930 and the TextToDisplay should be the cell value.

 

[sharky12345]

Sorted:

For Each Cell In Range("A2:A1930")Cell.Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="MASTERLIST!" & Cell.Address, TextToDisplay:=Cell.Value '"SD001"
Next