copy from a range name in one workbook another workbook

[still learning]

Hi
I'm trying to copy from a range name in one workbook sheet1 to another workbook sheet1
both workbooks are going to be open.
If I go to R37038C1..(A37038) and type in "=+'2024 review.xlsm'!datatocopy", it works
Using F8, the Goto part works ..nothing happens after and the sun ends

Sub copyfrom2014()
    Application.Goto Reference:="R37038C1"
    ActiveCell.Formula2R1C1 = "=+'2024 review.xlsm'!datatocopy"
End Sub

mike

 

[rlv01]

One way.

Sub copyfrom2014()
    Workbooks("2024 review.xlsm").Names("datatocopy").RefersToRange.Copy 'assumes "datacopy" is a workbook level name.
    ActiveSheet.Cells(37038, 1).PasteSpecial xlPasteValues 'edit if you want a different kind of paste.
End Sub

 

[still learning]

Hi rlv01
Perfect. Thank you
the range "datacopy" is in sheet 1 of the workbook


mike