I'm trying to copy links to my current workbook into another workbook. The following code works, but it's slow cause I have to do it multiple times... and it's inelegant. I usually try to avoid activating and selecting, but I can't seem to do the Paste Link:=True without it. Any ideas?
![]()
Set wbk = Application.ThisWorkbook Set wbk2 = Workbooks("Display Workbook.xlsx") Range("L13:O17").Copy wbk2.Activate Range("H12").Select ActiveSheet.Paste Link:=True wbk.Activate
thanks!
Kate
Bookmarks