ActiveSheet.Name into .RefersToR1C1 not working

[Fubi]

Hello i'm new to MrExcel.com

I have some issues with the following code below.
I tried to make a link to the sheet name into the offset property

It gives me an error:

Option Explicit


Sub Magazijnprint()
'
' PrintBereikBepalen Macro
' PrintBereikBepalen
'

'

'Productie Print

    ActiveWorkbook.Names("DynPrint").RefersToR1C1 = _
        "=OFFSET('ActiveSheet.Name'!R6C11,0,0,COUNTA('ActiveSheet.Name'!C17),7)"
    Application.CutCopyMode = False
    

End Sub

Could someone help me solve this?

 

[Fubi]

Problem solved!

Post can be closed

 

[smozgur]

Good to hear you the problem solved.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.