Sample Visual Basic procedure to print range of cells in Excel

This article contains a Microsoft Visual Basic for Applications macro that lets you print different parts of a worksheet without first having to select the range of cells or set the print area in the Page Setup dialog box. Microsoft provides...

support.microsoft.com