Printing named ranges

[Pallando_II]

Re:  EXCEL 2007

I have a series of ranges in one worksheet that together comprise a multi-page list of items (songs in playlists).  Til now, I've been selecting the range and printing it from the PRINT/SELECTION command.  This takes considerable time.

I've named a few of the ranges and tried to print them, but there seems to be no method to do just that.  Is there a way to print a named range in EXCEL? 

[#2]

@Pallando_II 

Please check this post https://excelribbon.tips.net/T006789_Printing_Multiple_Worksheet_Ranges.html

[#3]

@SergeiBaklan Any chance of doing it programmatically, (preferable C#)

[#4]

@Santhosh1010 

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")
    )
}