Invalid Reference Error when calling named Range 1

[Mantle51]

Hello,
I've created the following named range in code, however, it will not appear in the name box and when trying to select/copy/paste using GoTo method I get the above referenced.....Thanks

Dim FinalRow As Long
FinalRow = Cells(Rows.Count, 2).End(xlUp).Row

ActiveWorkbook.Names.Add Name:="NEW", RefersToR1C1:= _
"=Sheet1!R1C10:R & FinalRow & C10,Sheet1!R1C18:R & FinalRow & C18"
Application.Goto Reference:="NEW"

Selection.Copy
Sheets.Add
ActiveSheet.Paste

 

[Zathras]

Your formula needs a couple more quotes to allow proper concatenation for the result you want:

Dim FinalRow As Long
FinalRow = Cells(Rows.Count, 2).End(xlUp).Row
    
    ActiveWorkbook.Names.Add Name:="NEW", RefersToR1C1:= _
        "=Sheet1!R1C10:R" & FinalRow & "C10,Sheet1!R1C18:R" & FinalRow & "C18"
    Application.Goto Reference:="NEW"
    
    Selection.Copy
    Sheets.Add
    ActiveSheet.Paste

 

[Mantle51]

Oh man, why does simple syntax absolutely murder me?!!

Thank you very much....Mick