Printing named ranges

Question

Re:&nbsp; EXCEL 2007I have a series of ranges in one worksheet that together comprise a multi-page list of items (songs in playlists).&nbsp; Til now, I've been selecting the range and printing it from the PRINT/SELECTION command.&nbsp; This takes considerable time.&nbsp;I've named a few of the ranges and tried to print them, but there seems to be no method to do just that.&nbsp; Is there a way to print a named range in EXCEL?&nbsp;

sergeibaklan · Answer

Pallando_II&nbsp;
Please check this post&nbsp;https://excelribbon.tips.net/T006789_Printing_Multiple_Worksheet_Ranges.html

santhosh1010 · Answer

SergeiBaklan&nbsp;Any chance of doing it programmatically, (preferable C#)

sergeibaklan · Answer

Santhosh1010&nbsp;
Most probably yes, but that's not my territory. At least Office Script allows to set multiple print areas like
function main(workbook: ExcelScript.Workbook) {
    const sheet = workbook.getActiveWorksheet()
    sheet
        .getPageLayout()
        .setPrintArea(
            sheet.getRanges("rangeA, rangeB")
    )
}

Forum Discussion

Printing named ranges

3 Replies

Resources