How about
Code:
Sub AddFooterWithPageNumber()
Dim oSection As section
Dim oFooter As HeaderFooter
Dim oRng As Range
' Loop through each section in the document
For Each oSection In ActiveDocument.Sections
oSection.PageSetup.FooterDistance = CentimetersToPoints(1)
For Each oFooter In oSection.Footers
If oFooter.Exists Then
Set oRng = oFooter.Range
oRng.Fields.Add oRng, wdFieldPage, , False
oRng.ParagraphFormat.Alignment = wdAlignParagraphRight
' Set font properties
With oRng.Font
.Name = "Times New Roman"
.Size = 14
End With
End If
Next oFooter
Next oSection
lbl_Exit:
Set oSection = Nothing
Set oFooter = Nothing
Set oRng = Nothing
End Sub