How do you get the text?
Are you talking of a header on the worksheet or
about a header in the print set-up?

you can use
Range("A1")=Range(D25)
or
Range("A1")=InputBox ("Enter a Header")
or
Range("A1")="My Header"

--
steveB

Remove "AYN" from email to respond
"Danny Springer" wrote in message
...
I am trying to paste text into a header via code. I can't get it working.
Anyone?

Regards,
Danny