Thread: cell value in header or footer
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default cell value in header or footer
Sub CellInFooter22()
With ActiveSheet.PageSetup
.LeftFooter = "&""Algerian,Regular""&16" & Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 3 Aug 2008 18:25:01 -0700, Ms_M_o_n_i_c_a
wrote:

is it possible to put the contents/value of a cell in the header?

Reply With QuoteReply With Quote