#Excel for mac page setup vs print setup how to#
#Excel for mac page setup vs print setup free#

The page at which Excel starts printing.

More precisely, you can specify the following: You can use the From and To parameters to specify the pages that Excel prints. Let's take a closer look at the 9 parameters I list above: Parameters #1 And #2: From And To In such cases, the basic syntax looks roughly as follows:Įxpression.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName)

This is the case when you apply the PrintOut method to the Window (Window.PrintOut), Range (Range.PrintOut) and Chart (Chart.PrintOut) objects. In some cases, the IgnorePrintAreas parameter isn't applicable. “expression” is the object you want to print.Īs shown above, PrintOut has the following 9 parameters. The basic syntax of the PrintOut method is as follows:Įxpression.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName, IgnorePrintAreas) That is regardless of the object you're printing. Generally, the syntax and parameters are always the same. The object you refer to determines what Excel prints.īecause of the above, the Microsoft Dev Center lists different versions of the PrintOut method. In other words, you can refer to different objects. You can work with the PrintOut method at several different levels. However, you can't generally print hidden sheets. The PrintOut method allows you to print the referenced object. Let's start by looking at the VBA construct you use to print Excel worksheets, the… PrintOut Method This VBA Tutorial covers these 2 steps in detail. Generally, you can print or display a print preview with VBA in the following 2 easy steps:

#Excel for mac page setup vs print setup how to#

Let's start by taking a very basic look at the process your VBA code usually follows when printing from Excel or displaying a print preview: How To Print Or Display Print Preview In Excel With VBA

Macro Example #2: Specify Page Setup And Display Print Preview.

Macro Code Examples To Print With Excel.

Application.InchesToPoints And Application.CentimetersToPoints Methods.

HPageBreaks.Add And VPageBreaks.Add Methods.

HPageBreak.Location And VPageBreak.Location Properties.

HPageBreak.DragOff And VPageBreak.DragOff Methods.

HPageBreak.Delete And VPageBreak.Delete Methods.

PageSetup Properties Dealing With Differences Between Pages.

PageSetup Properties Dealing With Headers Or Footers.

PageSetup Properties That Center The Sheet On The Page.

PageSetup Properties Dealing With Margins.

PageSetup Properties Dealing With Print Quality.

PageSetup Properties Dealing With The Printing Of Certain Items.

PageSetup Properties Dealing With Printing Order And Basic Page Numbering.

PageSetup Properties Dealing With Print Area, Paper Size, Orientation And Scaling.

Parameters #6 And #8: PrintToFile And PrToFileName.

How To Print Or Display Print Preview In Excel With VBA.

The following Table of Contents lists the main topics I cover in this blog post:

#Excel for mac page setup vs print setup free#

You can get immediate free access to this example workbook by clicking the button below. It also has the data and worksheets that appear in the screenshots throughout this post. This workbook contains the example VBA Sub procedures I explain below. This Excel VBA Print Tutorial is accompanied by an example workbook.

In the second section, I go through 2 detailed VBA code examples that you can easily adjust and start using today.

The first section of this Tutorial introduces and explains several VBA constructs that are commonly used when printing Excel files.

My purpose with this blog post is to provide you with the most relevant information you need to appropriately set up your Excel files for printing and, as required, print or display a print preview. And if that's your purpose, then this VBA Tutorial is likely to be of help.

The good news is that you can easily automate most of these activities using VBA. You probably don't want to cause a bad impression simply because your file doesn't print properly.Ĭorrectly setting up and printing your Excel files takes some time. Knowing how to appropriately set up and print your files is, therefore, very important. Printing an Excel file may be the last step you take prior to distributing your work. 2 of the most common ways of achieving this are: The results of your efforts are probably beautiful and useful Excel worksheets.įrom time-to-time, you probably share the results of your work in Excel with others. If you're anything like me, you probably spend a substantial amount of time working in Excel.