View Single Post
 
Old 07-16-2020, 03:54 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Well for starters, if I wanted to know if there was a section break in my selection and if so, what type it was, I might try something like this.
Code:
Sub WhatIsIt()
  Dim aRng As Range
  If Selection.Sections.Count > 1 Then
    MsgBox "Section Break Type: " & Selection.Sections.Last.PageSetup.SectionStart
  Else
    MsgBox "You don't have a section break there"
  End If
End Sub
When it comes to the other break types, I'm seeing ascii values of 11 and 14 for column and line breaks.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote