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






  1. VBA / Excel / Access / Word
  2. Excel
  3. Worksheet Page Header Footer

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