Cell Content as Header?

  • Thread starter Thread starter alex3867
  • Start date Start date
A

alex3867

IS it possible to use the content of a particular cell as the
header/footer?

And if so, HOW!?

Thanks
Alex
 
Let’s say we want to use the content of cell Z100 in the center header:

Create a BeforePrint event macro containing the following line:
ActiveSheet.PageSetup.CenterHeader = Range("Z100").Value

To understand event macros, see:

http://www.cpearson.com/excel/events.htm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How could I display an excel cell contents in a page header ? 1
Header or Footer - Reference a Cell 5
Cell contents in header/footer 5
Excel Change starting page number in excel spreadsheet report 0
change header for each worksheet 1
headers in worksheet 4
PUT PAGE NUMBER INTO A SPECIFIC CEL? 1

Back
Top