Hi,

So currently I have a list of print ranges within a workbook where it'll lookup the sheet to refer to and what area to 'Print Area' before printing it into pdf.

Here's the current line I'm using:
 ActiveSheet.PageSetup.PrintArea = sPrintRange
sPrintRange = being a range, e.g. A1:B20

My question being, is there a way of using Name Manager rather than the current method that I'm using? Ideally I was thinking of defining the area to print out using Name Manager and the macro can simple lookup the name on the Name Manager and print into PDF.

Reason for the change is because the file is ever changing, so the range of the table could change and currently I need to manually change the range. Using Name Manager, this would change automatically.

Thanks