Excel-Macro: Paste Link to a new worksheet (Run-time error '424': Object required)

[dieserhering]

Hey,

I am currently working on a macro for duplicating a worksheet and pasting specific values from it into a new column of a remaining worksheet. However, whenever I try to paste link specific values to another worksheet, I receive the message 'Run-time error '424': Object required'. This is the whole macro code for the paste link:

Sub Macro17()
'
' Macro17 Macro
'


'
Range("C6:C18").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Feedback Tracker").Select
ThemeEffectScheme.Paste Link:=True
EndSub



When I press the debug button, excel highlights the following line: 'ThemeEffectScheme.Paste Link:=True'
Does anyone know how to fix that issue? Thank you so much in advance!

 

[Trevor_S]

The macro shown doesn't include Dim or Set lines for ThemeEffectScheme.
Assuming that ThemeEffectScheme is the name of the worksheet, you need to add these two lines to the start of your macro:

Dim ThemeEffectScheme As Worksheet
Set ThemeEffectScheme = Sheets("ThemeEffectScheme")