View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How to select and print custom data (eg: cell value) in excel head



On Wed, 12 Apr 2006 12:44:02 -0700, Ned wrote:

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


Gord Dibben MS Excel MVP