View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default point to a cell from the Custom footer

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


Gord Dibben MS Excel MVP

On 29 Mar 2007 09:54:39 -0700, wrote:

Is it possible to point on the Custom footer to a cell on the sheet?