Vba Formatting

**kamaflage** · 07-16-2015, 08:06 AM

Hello Experts,

I have recorded a macro to:
1. change pager orientation to landscape
2. change page margins to narrow
3. change font size to 8

What i got is:

Please Login or Register  to view this content.

Can someone please help me to make this look cleaner and more understandable? I am using word 2007.

**macropod** · 07-17-2015, 12:27 AM

What are you selecting - the entire document, or just part of it? Why are you selecting anything rather than working with Range objects? Does the Selection span one or more Section breaks? What do you mean by 'change page margins to narrow'? Why are you applying direct formatting to the font instead of changing the underlying Style definitions?