You can copy the contents of the cell and then in Page Layout view, paste into the header. Format as you like.

I haven't found any code to do it...yet.