Roy_Excel_Island_Apps
Board Regular
- Joined
- Oct 9, 2018
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
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!
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!