Open the Define Name dialog (Ctrl-F3 is the shortcut) and make sure the name
TestNamedRange appears and that it refers to a cell.

--
Jim
wrote in message
oups.com...
|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?
|