kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
<code class="lang-vb" style="line-height: 19px; -webkit-font-smoothing: auto; font-family: monospace, monospace; font-size: 0.875rem; border-radius: 2px; display: block; padding: 0px; border: 0px; direction: ltr; box-sizing: inherit;">
I used this code trying to make sure my default papersize is used but I get runtime error 1004
Unable to set the pagesize property of the pagesetup class.
Any help?
Can I set for a postcard size?</code>
Code:
Worksheets([COLOR=#A31515]"Sheet1"[/COLOR]).PageSetup.PaperSize = xlPaperQuarto
I used this code trying to make sure my default papersize is used but I get runtime error 1004
Unable to set the pagesize property of the pagesetup class.
Any help?
Can I set for a postcard size?</code>