Can I replace different urls in selected column with "Click Here" with a Macro?

How do I create this Excel macro? Change an entire column of different clickable URLS to "Click Here"? For example: I have an entire clickable column of different URLs. I can change each of them individually to "Click Here" but that would take too long (over 6,000); and I can even record a macro to do that but all it does is record the same URL to all the fields in the column. What I want is to change all the different URLS to the display text "Click Here" for one selected column TIA.

I hope it is possible

A sample file might help but perhaps along the lines of:

Sub Example()
    Dim rngD As Range, rngC As Range
    On Error Resume Next
    Set rngD = Intersect(ActiveSheet.UsedRange, ActiveSheet.Columns(1)).SpecialCells(xlCellTypeConstants, xlTextValues)
    On Error GoTo 0
    If Not rngD Is Nothing Then
        For Each rngC In rngD.Cells
            With rngC
                If .Hyperlinks.Count > 0 Then
                    .Hyperlinks(1).TextToDisplay = "Click Here"
                End If
            End With
        Next rngC
    End If
    Set rngD = Nothing
End Sub

in the above Hyperlinks are assumed to be listed in Column A and are not being generated via HYPERLINK function.

Hello DonkeyOte,
Thanks for the reply. I have included a small sample (fishing rods) as an attachment. What I want is to change all the urls in the column under "website" to "Click Here". The attachment is a smaller version with just four websites but I would like to do it for a larger amount of urls in the column.

Thanks so much for your help I have searched everywhere online and noone seems to know. You're my last hope.

The code provided should do what you requested you just need to change Columns(1) to Columns("C") (or 3 but in retrospect using a letter is more transparent)

Alternatively, if you prefer to avoid VBA, you could use formulae in an adjacent column and hide Column C, eg:

D2:
=IF([Website]="","",HYPERLINK([Website],"Click Here"))
should add to your table automatically