Forum Discussion
Pallando_II
Oct 16, 2019Copper Contributor
Printing named ranges
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 PR...
Santhosh1010
Sep 29, 2023Copper Contributor
SergeiBaklan Any chance of doing it programmatically, (preferable C#)
SergeiBaklan
Sep 29, 2023MVP
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")
)
}