G
Gojavid
Does anyone know of a way to get a cell value in a page header without
using VBA?
using VBA?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
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).
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).
D
Dave Peterson
Go through the menu and type it in????
Does anyone know of a way to get a cell value in a page header without
using VBA?
G
Gojavid
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
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
G
Gojavid
I've just added some code to the worksheet_change event. Thank you
both for the response.
both for the response.
D
Dave Peterson
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.
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.
G
Gojavid
Dave,
That is a nifty little feature and it will help with a bunch of my
other projects. Sweet! Thanks!
-Dave
That is a nifty little feature and it will help with a bunch of my
other projects. Sweet! Thanks!
-Dave