Paste contents of Named Range

[polarisking]

I must be doing something incredibly stupid. I have a named range with 5 pieces of data, say A1 thru A5. I want to paste this data into another sheet using the Named Range. Can't do it. Any ideas?

 

[pecoflyer]

Which Excel version are you using ?
Perhaps https://www.automateexcel.com/how-to/paste-range-names/

 

[polarisking]

2016

 

[polarisking]

NM. Once I upgraded to 365 everything's working the way it's supposed to.