Word Macro Adjusts Page Orientation

[devanrose33]

Hi,

I'm writing a macro in Microsoft Word 2010. The macro itself is inserting and deleting bookmarks based on user inputs in an excel document.

There is one table in this document that is 6 pages long and I adjusted the orientation to Landscape for these pages only. The rest of this document is portrait.

When I run my macro, everything runs correctly but it changes these few pages orientation back to portrait. Is there any kind of code I can insert in the code to prevent the page setup from changing?

Or, if not, a way to tell the word VBA to adjust the orientation from page # - #

Thanks!

 

[starl]

Word shouldn't arbitrarily be changing your page orientation. I'm going to assume that when it's deleting a bookmark, it's also deleting a section break that's being used to change the page orientation.

 

[devanrose33]

Starl,

Yes, you are correct! Thank you!

The issue is that one of the section breaks for this orientation change had an extra paragraph right before it. I have a piece of code at the end to delete all extra paragraphs and this was getting deleted. Deleting the paragraph before the section break eliminated this issue.