VBA to Replace HyperLinks - Head Hurts Terribly

[VenturSum]

Guys & Gals..

My project requires me to replace hyperlinks in a file.

And I'm can't seem to get the new data back into Excel

I've extracted the code and my result table looks like:
Worksheet index | Hyperlink Number | Address | TextToDisplay

I don't want to ADD the hyperlink.
I just want to replace the value

This code does NOT Work:
Worksheets(WSIndx).Hyperlinks(HLIndx).Item.Address = "'" & ws.Cells(j, 7)
Worksheets(WSIndx).Hyperlinks(HLIndx).Item.TextToDisplay = ws.Cells(j, 9)

I believe my sytax is wrong.
I believe pound signs are needed #, just don't know how.
I can't find reference.

ANY Help Would be appreciated.

John,
In Annapolis.

 

[Von Pookie]

I highly doubt there will be pound signs involved.

What are you trying to replace the hyperlinks with?

 

[VenturSum]

Thanks,

I got it to work...
Here's the code..

     With Worksheets(WSIndx).Hyperlinks(HLIndx)
          '.Anchor =
           .SubAddress = "'" & ws.Cells(j, 12)
           .TextToDisplay = ws.Cells(j, 9)
           .Name = ws.Cells(j, 7)
           .Range = ws.Cells(j, 14)
    End With