ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

Valid HTML 4.01 Transitional

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Document: Description: Sort by date
Change the default printer Change the default printer with a macro. Print to network printers. 2005-06-03
Insert headers and footers This example macro inserts a header/footer in every worksheet in the active workbook. It also inserts the complete path to the workbook. 2004-06-03
Print all workbooks in a folder With these macros you can print all workbooks in a selected folder. You have more control with what is printed than you have if you do this from Windows Explorer. 2000-02-04
Print multiple selections on one sheet If selected multiple cell ranges is printed out on different sheets, you can use this macro example to print all the selected areas on one sheet. 2000-02-04
Print the pages in reverse order With some printers it can be useful to be able to print the pages of a worksheet in reverse order. 2000-02-04
Returning the page range addresses from a worksheet If you need to get the range address for each printed page you can use this function 2004-10-08
Select a printer tray before printing In Excel you don't have the opportunity to set the properties FirstPageTray or OtherPagesTray like you can in Word. It's possible to create a simple solution by using SendKeys. 2000-02-04
Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2024    Ole P. Erlandsen   All rights reserved
E-mail Contact Address