Search and replace - VBA

[Razzy]

If my string "A" is empty it replaces FIL1 with nothing - great.

But if my string contains the filepath that I want, it does not do anything?

Hm...

    Cells.Replace What:="FIL1", Replacement:=A, LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
        ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

 

[Razzy]

A = "='C:\Users\John\Downloads\Rabbit - 06.09.2020\[TK.xlsm]'!"

 

[Razzy]

Got it!

I had to remove the last: "'!" like:

A = "='C:\Users\John\Downloads\Rabbit - 06.09.2020\[TK.xlsm]"