Cell Value in Header / Not Using VBA

  • Thread starter Thread starter Gojavid
  • Start date Start date
G

Gojavid

Does anyone know of a way to get a cell value in a page header without
using VBA?
 
It's not possible using the GUI.

You could create a similar effect by setting a link in a cell in Row 1
to your cell of interest, then have that row print on every page (set
the top margin very small).
 
Dave,
That's an interesting suggestion, but since the cell value will
change often I'm not sure that's going to cut it.

Thanks anyways!
- Dave
 
I've just added some code to the worksheet_change event. Thank you
both for the response.
 
If you still don't want to use VBA, maybe you can change your requirements.

Instead of putting the value in the header, you could put it in a cell.

Then use: File|Pagesetup|Sheet tab|Rows to repeat at top.

And make sure you include the row that includes that cell.
 
Dave,

That is a nifty little feature and it will help with a bunch of my
other projects. Sweet! Thanks!

-Dave
 
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
Excel VBA 0
Excel VBA 1
vba code help for multiple string searching 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Insert last saved date into header 9
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Extract specific information from the body of outlook mail to an Excel File using VBA 0

Back
Top