Set center footer to your string text : Worksheet Page Header Footer « Excel « VBA / Excel / Access / Word






Set center footer to your string text

 
Sub FilePathInFooter()
  Dim i As Integer
  
  For i = 1 To Worksheets.Count Step 1
    Worksheets(i).PageSetup.CenterFooter = "your center footer"
  Next i
End Sub

 








Related examples in the same category

1.To print header, control the font and to pull second line of header (the date) from worksheet
2.Set the center footer to file path