Does anyone know of a way to get a cell value in a page header without
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.

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?

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

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.

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

Dave,

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

-Dave