No.

What's wrong WITH using VBA?

Just in case you change your mind...........

Sub CellInHeader()
With ActiveSheet
.PageSetup.CenterHeader = .Range("A1").text
End With
End Sub


Gord Dibben Excel MVP

On Wed, 14 Sep 2005 18:04:54 -0500, jake1729
wrote:


Is there a way to refer to a specific cell from the page header WITHOUT
using VBA? Thank you!