You can use the same method to create many print functions in Excel using VBA. Steps for creating the print function button are the same; just the command syntax differs.

How to Do Selective Printing in Excel. When you need to print only a limited range of worksheet data, Microsoft Excel 2010 offers a "Set Print Area" option to help you manage your print content.

Excel's print function is quite powerful, but you have to do a bit of digging to take full advantage of its capabilities. Here are just a few of the options open to you when you print with Excel.