Find and Replace based off Hyperlink Display

[kingsdime29x]

Hello,

I am trying to see if there is a way that if i try to find the hyperlink and when I enter in the hyperlink as the item to find, I would like for it to replace only the display for the hyperlink, not the hyperlink itself.

I have attached a spreadsheet and an example of what I am looking for is below:

Find the URL within the display highlighted in yellow: http://www.baseball-reference.com/bo...99804161.shtml
Replace Display with: 4/16/98 6:00 AM

Find the URL within the display highlighted in yellow: http://www.baseball-reference.com/bo...99804162.shtml
Replace Display with: 4/16/98 12:00 PM


Any help to make this happen would be greatly appreciated. Thank you in advance.

[José Augusto]

Hi

I made the function Function FindTextinHyp(Txt As String, Source As Range) As String that locates the cell that contains the hyperlink Txt in the cell range Source
The procedure Sub ChangeDisplayHiperlink (TXT1 As String, Source As Range, Value As Variant) uses the previous function to update the cell found by the function with the Value you passed

Please Login or Register  to view this content.

See if this helps.
Best regards