Replacing hyperlinks with find and Replace

[Abubakr Masood]

Hi all,

Hope everyone is doing fine in everyday life,

I am having problem with a macro that I have recorded, it copies updated Link using Find and replace function but the vba code have harcoded the link, it can only be used once then it is useless, Updated link is in a cell as text.
I am unable to search up any solution for this problem I need urgent help ! Problem is highlighted in the code below.

>>> Your urgent means for You that You're late <<<
>>> use code - tags >>>

Sub Test1()

Range("H1").Select
Selection.Copy
Range("H2").Select
Application.CutCopyMode = False
Selection.Copy
Range("B4:V5").Select
Range(Selection, Selection.End(xlDown)).Select
'    highlighted What & Replacement
Selection.Replace What:= _
"C:\Users\AB-Uc\Desktop\[Landing cost 31-Dec-2022.xlsx]Sheet1'!$F$7" _
, Replacement:= _
"C:\Users\AB-Uc\Desktop\Junk\[Budgeted sale.xlsx]Summary'!$A$21" _
, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat _
:=False, ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

End Sub

 

[Marc L]

Hi, follow any Excel forum rules for cross-posting :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org