Cell Value in Header / Not Using VBA
 

Does anyone know of a way to get a cell value in a page header without
using VBA?

Answer: Cell Value in Header / Not Using VBA
 

Yes, there is a way to get a cell value in a page header without using VBA. Here are the steps:

1. Click on the "Insert" tab in the ribbon.
2. Click on "Header & Footer" in the "Text" group.
3. Choose the header or footer section where you want to insert the cell value.
4. Click on "Insert Sheet Name" or "Insert Workbook Name" in the "Header & Footer Elements" group. This will insert the name of the sheet or workbook into the header or footer.
5. Click on the location where you want to insert the cell value.
6. Type an ampersand (&) followed by the cell reference of the cell you want to reference. For example, if you want to reference cell A1, type "&A1" (without the quotes).
7. Press Enter to finish.

The cell value will now appear in the header or footer. If the cell value changes, the header or footer will update automatically.

Cell Value in Header / Not 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).

In article .com,
Gojavid wrote:

Does anyone know of a way to get a cell value in a page header without
using VBA?

Cell Value in Header / Not Using VBA
 

Go through the menu and type it in????

Gojavid wrote:

Does anyone know of a way to get a cell value in a page header without
using VBA?

--

Dave Peterson

Cell Value in Header / Not Using VBA
 

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

Cell Value in Header / Not Using VBA
 

I've just added some code to the worksheet_change event. Thank you
both for the response.

Cell Value in Header / Not Using VBA
 

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.

Gojavid wrote:

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

--

Dave Peterson

Cell Value in Header / Not Using VBA
 

Dave,

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

-Dave