I know the code to put into the BeforePrint event handler to name a workbook the "filename" is:
Worksheets("Sheet1").PageSetup.LeftHeader = ActiveWorkbook.FullName
Instead I'm trying to put a cell content into the header off of worksheet "info", cell number C7
Worksheets("HAHA Letter").PageSetup.LeftHeader = Worksheets("Info").C7
Now I know that's not it...what would the syntax be?