Print Range using Name Manager VBA

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:

Please Login or Register  to view this content.

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