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