Select a printer tray before printing using VBA in Microsoft Excel

When you print documents from Word with VBA it's possible to select which printer tray the document is supposed to get a sheet from. In Excel you don...

Print the pages in reverse order using VBA in Microsoft Excel

The macro below can be used to print the pages of a worksheet in reverse order. Sub PrintInReverseOrder() Dim TotalPages As Long, p As Long Tot...

Print multiple selections on one sheet using VBA in Microsoft Excel

If you select multiple cell ranges on one sheet and tries to print out selected cells you will get one sheet for each of the selected areas. The fol...

Print all workbooks in a folder using VBA in Microsoft Excel

  In this article, we will create a macro to print all the Excel files within a folder. We have some Excel files within a folder which we want ...

Insert headers and footers using VBA in Microsoft Excel 2010

If you want to insert certain information in the header / footer of the worksheet like the file name / file path or the current date or page number, y...

Change the default printer using VBA in Microsoft Excel 2010

In this article we will learn how to change the default printer by using VBA in Microsoft Excel 2010. Most of the computer systems will be mapped t...

Conditional formatting depending on a cell comment using VBA in Microsoft Excel

Question: How can I make a conditional formatting depending on a cell commentary? Answer: Insert the following code into the standard module Formula...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube