Header based on cell

Is it possible to change the left and right sides of a header based on a cell? Can the value of that cell be placed in the header prior to printing the file?

Thanks

Sorry I did not think it necessary to add a spreadsheet for simple code to add do something like with sheet1 .header = .Range("C4").value. to header. I'm not In front of my computer so I can add a file tonight when I get home.