Set Print Area to named range before saving as PDF and attaching in new email

Hi,

Another questions on this piece of code; how can I set the print area as List where list is a named range.

I don't want this to always be the print area, simply for when I run this code.

If there is something I can use at the start of the code to set print area = List that would be helpful so I can move into other code.

Thanks

Dave

Please Login or Register  to view this content.

Hi,

Thanks for the advice, however I've added to my test workbook and it's not working.

Can you have a look to advise please?

Regards

Dave

Boom nailed it, one of those days that I couldn't spot that either!

Thanks for your help