I'm sure there is a way of doing this but I haven't been able to figure it
out ...

I want to include some variable text in a sheet header - the text being
contained in a cell within the same workbook. I can find ways of including
the sheet name or file name in the header but not a specific cell's
contents.

Can somebody point me in the right direction?

Thanks.

Terry

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterHeader = .Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP

On Thu, 6 Sep 2007 22:00:29 +0100, "Terry Bennett"
wrote:

I'm sure there is a way of doing this but I haven't been able to figure it
out ...

I want to include some variable text in a sheet header - the text being
contained in a cell within the same workbook. I can find ways of including
the sheet name or file name in the header but not a specific cell's
contents.

Can somebody point me in the right direction?

Thanks.

Many thanks Gord!


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Terry

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterHeader = .Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP

On Thu, 6 Sep 2007 22:00:29 +0100, "Terry Bennett"

wrote:

I'm sure there is a way of doing this but I haven't been able to figure it
out ...

I want to include some variable text in a sheet header - the text being
contained in a cell within the same workbook. I can find ways of
including
the sheet name or file name in the header but not a specific cell's
contents.

Can somebody point me in the right direction?

Thanks.