Paste Link Error in VBA

[Roy_Excel_Island_Apps]

Hi guys,

I'm a Software Engineer in Excel at work. I've a project where I have to paste links with other cell references (e.g. =TEST7!BG13).
Sometimes when I run my code I get a "No link to paste" error. Any idea why?
The data to process is always the same.

Piece of the code:
Finance_Data.Cells(2, Template_Dienst_ToCopy.Range(RangeName).Column - 11 + x).Select
RangeName = Replace(cell.Value, " '", "_")
ShtDienst.Cells(j, Template_Dienst_ToCopy.Range(RangeName).Column).Copy
Finance_Data.Paste Link:=True
Next

Thanks!