-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
xllandscape
-
B
Compile error
Hi all, I keep getting compile error "End With without With" with: Private Sub CommandButton1_Click() With ActiveSheet If OptionButton1.Value = True Then .PageSetup.PrintArea = "$a$1:$z$55" .PageSetup.Orientation = xlLandscape .PageSetup.LeftMargin =...- bademployee
- Thread
- .pagesetup.leftmargin .pagesetup.rightmargin compile end xllandscape
- Replies: 2
- Forum: Excel Questions
-
M
VBA was working fine. now adding blank pages
Through this page I received excellent assistance getting a VBA to print the pages from my call schedule. I copy forward each month and make changes and it works great!!!! Until this month when it started adding blank pages. In particular 4 blank pages with the appropriate footer after the...- mrpwagner
- Thread
- .printarea activesheet.pagesetup end pages xllandscape
- Replies: 1
- Forum: Excel Questions
-
P
small adjustment needed for Printing code
Hi, I have the following code to print pages 1 and 2 of any sheet named with a 4-digit number ... For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then ws.Range("P22:U22").Font.Color = vbWhite ws.Range("P22:U22").Interior.Color = vbWhite...- palaeontology
- Thread
- pages vbwhite ws.pagesetup.orientation ws.printout xllandscape
- Replies: 0
- Forum: Excel Questions
