How do I add a cell reference in a header?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to add a cell reference in the header of an Excel document. The
workbook allows a user to select choices from a drop-down menu and pulls the
specific data into summaries, but I would also like the selection to change
the header each time.
 
Hi
only possible with VBA using an event procedure. e.g. put the following
code in your workbook module:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In Me.Worksheets
With wkSht.PageSetup
.CenterHeader = wkSht.range("A1").value
End With
Next wkSht
End Sub
 
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 do I reference a cell to automatically update in a header 1
Change Header on Multiple Sheets without Changing Other Formatting 1
Drop Down List Contains the List Header Row 1
reference tabs in a summary sheet as column headers 6
Access Page Header with merge field 0
Change Header & Footer Info w/ Worksheet Option Buttons 1
How do I put a specific cells information in the header or footer. 2

Back
Top