How to Print Odd Or Even Pages In Excel 2007, 2010, 2013 & 2016
If you want to print both sided page in MS-Excel. Then use Odd Or Even option to print Pages In Excel 2007, 2010, 2013 & 2016 (Know how?)
#MicrosoftExcel #MSExcel
---------------------Macro Code-----------------------
Sub Odd_Even_Print()
'UpdatebyGeteSolutions20160901
Dim xTotalPages As Long
Dim xStartPage As String
Dim xPage As Integer, xYesorNo
Application.ScreenUpdating = False
xStartPage = InputBox("Enter 1 for Odd, 2 for Even", "Kutools for Excel")
If xStartPage = "" Then Exit Sub
xTotalPages = ActiveSheet.PageSetup.Pages.Count
xYesorNo = MsgBox("Are you sure to print?", vbYesNo, "Kutools for Excel")
If xYesorNo = vbYes Then
For xPage = Int(xStartPage) To xTotalPages Step 2
ActiveSheet.PrintOut from:=xPage, To:=xPage
Next
Else
Exit Sub
End If
Application.ScreenUpdating = True
End Sub
-------------------Related Videos------------------
►[✌Types] Create Drop Down List in Excel | Make drop down list in excel | Excel drop down list: • [✌Types] Create Drop Down List in Exc...
►⚡Use Flash Fill for MAJOR Time Saving in Excel | Split cells | Combine Cells | Change Case in Excel: • ⚡Use Flash Fill for MAJOR Time Saving...
►Text Filter in Excel | Excel advanced filter contains text: • Text Filter in Excel | Excel advanced...
►[VLOOKUP explained] VLOOKUP formula in Excel with example | VLOOKUP example between two sheets: • [VLOOKUP explained] VLOOKUP formula i...
►[Trim Function] How to remove extra spaces in MS-Excel | Remove blank spaces in excel: • [Trim Function] How to remove extra s...
►[Datedif Excel] How to calculate date difference in Excel | Excel Date Difference: • [Datedif Excel] How to calculate date...
►[Easy Way] How to Convert Row to Column in excel (Vertical to Horizontal) | Transpose Data in Excel: • [Easy Way] How to Convert Row to Colu...
►How to Split cells in excel | How to split one column into multiple columns in Excel: • How to Split cells in excel | How to ...
►How to Save Macro Code Permanently in Excel… as part of the programme: • How to Save Macro Code Permanently in...
►How to insert/add watermark in MS-Excel 2007, 2010, 2013 & 2016 | how to put watermark in excel: • How to insert/add watermark in MS-Exc...
►How to Convert Excel (.csv) to .vcf file Directly | csv to vcf | Excel to vcf converter: • How to Convert Excel (.csv) to .vcf f...
►How to Import Unlimited Contact From Excel to Mobile: • How to Import Unlimited Contact From ...
►How to Find & Remove Duplicates in Excel | Highlight Duplicates in Excel: • How to Find & Remove Duplicates in Ex...
►How to Combine text from two or more cells into one cell in MS Excel: • [Concatenate Excel] How to Combine te...
►Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel: • Change Case in Excel without Formula ...
►Convert Number to Words in Excel 2010,2013 & 2016 Without using Macro Code | Spell Number in excel: • Convert Number to Words in Excel 2010...
►How to Print Long Sheet in Minimum Page (Excel Page Setup & Print): • How to Print Long Sheet in Minimum Pa...
-------------------------Follow us----------------------
►For more videos Updates please Subscribe our Youtube Channel (Get eSolutions) - / getesolutions
► Facebook: www.facebook.com/getesolutions
► Twiter: twitter.com/getesolutions
► Website : http://getesolutions.com
Keep Watching, Keep learning...!!!
~-~~-~~~-~~-~
Please watch: "How to Use Macro in Excel | How to Create Macros in Excel | Macro Record kaise kare | Macro in Excel"
• How to Use Macro in Excel | How to Cr...
~-~~-~~~-~~-~