displaying a cell's value in a page header when printing

  • Thread starter Thread starter Paul James
  • Start date Start date
P

Paul James

Is there a way to display the value in a cell in a custom page header?

(Assume the cell's range is named "CompanyName" and it's located on a
worksheet named "DataEntry").

Thanks in advance.

Paul
 
Paul

Sub CellInFooter()
With Sheets("Data Entry")
.PageSetup.CenterFooter = .Range("Company Name").Text
End With
End Sub

Could also be fitted into BeforePrint code in ThisWorkbook.

Gord Dibben XL2002
 
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
placing a reference to a cell in a print header 5
After Macro runs, no cell activated - what am I missing? 2
Headers & Footers _auto update info from a cell in the worksheet 4
no of pages in excel worksheet (not workbook) 9
How can I use custom properties in an Excel header or formula? 5
Insert automatic page numbering into a cell, not a header or foote 1
Cell content in custom header: How? 5

Back
Top