What causes runtime error 1004?
If you've created a name that refers to a string you can do this:
ActiveSheet.PageSetup.RightHeader = Evaluate(Names("HeaderString").Value)
The Evaluate is to peal off the "=" and quotes you see around the definition
of the name in the Define Name dialog.
--
Jim
wrote in message
oups.com...
| Jim-
| The named range had been set up as a variable, with a value applied to
| the named rather than referring to a range. When I changed it to refer
| to a range, the code worked: thanks!
|
| What is the syntax to apply the named range that has a forced value
| attached?
|
| Thanks for your help!
|
|