Cell Value in Header / Not Using VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gojavid - 15 Aug 2007 17:07 GMT

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

Reply to this Message

JE McGimpsey - 15 Aug 2007 17:17 GMT

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).

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

Reply to this Message

Gojavid - 15 Aug 2007 20:57 GMT

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

Reply to this Message

Dave Peterson - 15 Aug 2007 20:17 GMT

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?

Signature

Dave Peterson

Reply to this Message

Gojavid - 15 Aug 2007 20:56 GMT

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

Reply to this Message

Dave Peterson - 15 Aug 2007 22:00 GMT

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'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

Signature

Dave Peterson

Reply to this Message

Gojavid - 16 Aug 2007 17:22 GMT

Dave,

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

-Dave

Reply to this Message