Erlandsen Data Consulting

ERLANDSEN DATA CONSULTING

Excel & VBA Tips

Document:	Description:	Sort by name
Change the default printer	Change the default printer with a macro. Print to network printers.	2005-06-03
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
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 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 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 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
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