Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-30-2018, 08:10 PM
macropod's Avatar
macropod macropod is offline VBA  to Delete Single Page Windows 7 64bit VBA  to Delete Single Page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the following. most of the complication in the code is related to what happens when you delete the last Section in a document.
Code:
Sub Demo()
Application.ScreenUpdating = False
Dim HdFt As HeaderFooter, Sctn As Section
With Selection.Sections(1)
  If ActiveDocument.Sections.Count > 1 Then
    If .Index = ActiveDocument.Sections.Count Then
      Set Sctn = ActiveDocument.Sections(.Index - 1)
      With .PageSetup
        .DifferentFirstPageHeaderFooter = Sctn.PageSetup.DifferentFirstPageHeaderFooter
        .OddAndEvenPagesHeaderFooter = Sctn.PageSetup.OddAndEvenPagesHeaderFooter
      End With
      For Each HdFt In .Headers
        If Sctn.Headers(HdFt.Index).Exists Then
          .Range.FormattedText = Sctn.Headers(HdFt.Index).Range.FormattedText
          .Range.Characters.Last.Delete
        End If
      Next
      For Each HdFt In .Footers
        If Sctn.Footers(HdFt.Index).Exists Then
          .Range.FormattedText = Sctn.Footers(HdFt.Index).Range.FormattedText
          .Range.Characters.Last.Delete
        End If
      Next
      .Range.Delete
      .Range.Characters.First.Previous.Delete
    Else
      .Range.Delete
    End If
  Else
    .Range.Delete
  End If
End With
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA  to Delete Single Page Delete Character on Single Line Only Tye30 Word VBA 8 04-20-2017 08:40 PM
Is there a way to exctract a single page from Word? mobileone Word 1 04-05-2017 02:27 PM
convert booklet to A4 single page mickfromoz Publisher 0 10-15-2016 05:28 PM
VBA  to Delete Single Page How do you view a single page delboy Word 29 01-25-2013 06:42 PM
VBA  to Delete Single Page single page formatting Ridgerunner Word 8 01-29-2012 06:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft