Determine if previous "character" is a section break

[chrscote]

I have written a function in a macro that will add an intentional blank page when it encounters a certain tag (which is inserted from DOORS script) and it is on an even-numbered page. There are cases, however, when a Section Break is not needed such as when it changes from a portrait layout to landscape or vice versa. Is there a way in VBA to determine if the previous "character" is a section break?

Chris

 

[macropod]

The simplest approach is to test whether that character is ASCII 12 - Chr(12).

 

[chrscote]

Thank you. I didn't realize the section break had its own character value.

 

[macropod]

Chr(12) applies to Section breaks and manual page breaks alike. More sophisticated methods are available to differentiate the various type of Section break from each other and from manual page breaks