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...
SergeiBaklan
Oct 17, 2019MVP
Please check this post https://excelribbon.tips.net/T006789_Printing_Multiple_Worksheet_Ranges.html
- Santhosh1010Sep 29, 2023Copper Contributor
SergeiBaklan Any chance of doing it programmatically, (preferable C#)
- SergeiBaklanSep 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") ) }