Want link my header to a cell value

A

astrange

I would like to populate the value of my header based on the value of
cell H1.

Any thoughts? It seems like the only options when I go to File > Page
Set Up> Header/Footers tab is to type in the text each time.

I have to create a bunch of printables based on a series of lists that
I was given in excel. My idea was to create a template where I could
just copy in each list and print it out. However, I am trying to avoid
having to type the header manually each time. I could just use another
cell as the title but I would like to try to use the header if
possible.

Thanks, Jason.
 
G

Gord Dibben

Jason

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").text
End With
End Sub

Change "footer" to "header"


Gord Dibben MS Excel MVP
 
A

astrange

That was exactly what I was looking for. Thanks for your help. I
appreciate it. Jason
 

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
Header Text 1
cell value in header or footer 3
can I use a cell content to auto-populate to a header in excel? 9
How do I include a cell-value in Excel header? 3
How to use 'header' tags<h1>etc in web pages made w/ Excel ??? 2
Customize Header From Cell Value 1
How do I set a custom header to a cell value in Excel 2003? 3

Top