![]() |
#14
|
||||
|
||||
![]()
The error occurs if there are fields in the footer and the field codes are not visible. Fix it with
Code:
Sub Macro1() Dim oSection As Section Dim oFooter As HeaderFooter Dim oRng As Range Dim bCodes As Boolean bCodes = ActiveWindow.ActivePane.View.ShowFieldCodes ActiveWindow.ActivePane.View.ShowFieldCodes = True For Each oSection In ActiveDocument.Sections For Each oFooter In oSection.Footers If oFooter.Exists Then Set oRng = oFooter.Range With oRng .Collapse 0 .Fields.Add Range:=oRng, Type:=wdFieldIf, Text:="{PAGE} = {NUMPAGES} ""last page""", PreserveFormatting:=False .Collapse 1 .MoveEndUntil "}" .End = .End + 1 .MoveStartUntil "{" oRng.Select .Text = "" .Fields.Add Range:=oRng, Type:=wdFieldPage, PreserveFormatting:=False .Collapse 0 .MoveEndUntil "}" .End = .End + 1 .MoveStartUntil "{" .Text = "" .Fields.Add Range:=oRng, Type:=wdFieldNumPages, PreserveFormatting:=False .Fields.Update End With End If Next oFooter Next oSection ActiveWindow.ActivePane.View.ShowFieldCodes = bCodes lbl_Exit: Set oSection = Nothing Set oFooter = Nothing Set oRng = Nothing Exit Sub End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) | slaycock | Word VBA | 0 | 02-18-2017 07:00 AM |
![]() |
PRA007 | Word VBA | 2 | 02-19-2016 12:52 AM |
![]() |
paik1002 | Word VBA | 1 | 12-17-2015 04:51 AM |
Selection or Range | Tommes93 | Word VBA | 1 | 04-10-2014 02:50 AM |