I have a macro that consists of these 3 lines:
Sub Macro2()
ActiveSheet.PageSetup.RightHeader = Range("TestNamedRange")
End Sub

It's meant to include the value of a textual named range in a header.
This macro generates
Runtime error 1004
Method 'range' of object '_global' failed

What causes this error? I have tried different variations of
declarations, searching this forum, and traded posts with Bob Phillips
(no aspersions intended-I think the thread just faded) to no avail.
Any ideas?