UncleBajubjubs
Board Regular
- Joined
- Jul 11, 2017
- Messages
- 111
- Office Version
- 2010
Hello, I have a line of code which is
<code>
ActiveSheet.PageSetup.PrintArea = "
$A$14:$P$87,$A$88:$P$155,$A$156:$P$221,
$Q$14:$AE$87,$Q$88:$AE$155,$Q$156:$AE$221,
$AG$14:$AV$87,$AG$88:$AV$155,$AG$156:$AV$221"
</code>
The first 7 pages print properly, but the last two are wrong. After running the code, page 8 goes from AG88:AV168, and page 9 is then AG169:AV221.
I have no idea what is wrong, the first seven all work properly, any ideas?
<code>
ActiveSheet.PageSetup.PrintArea = "
$A$14:$P$87,$A$88:$P$155,$A$156:$P$221,
$Q$14:$AE$87,$Q$88:$AE$155,$Q$156:$AE$221,
$AG$14:$AV$87,$AG$88:$AV$155,$AG$156:$AV$221"
</code>
The first 7 pages print properly, but the last two are wrong. After running the code, page 8 goes from AG88:AV168, and page 9 is then AG169:AV221.
I have no idea what is wrong, the first seven all work properly, any ideas?
