Create a google script function for Google Sheets to print a predefined range of cells to PDF and save the PDF file in a preselected Google Drive directory:

Create a google script function for Google Sheets to print a predefined range of cells to PDF and save the PDF file in a preselected Google Drive directory: Select a range of cells based on predefined named ranges (UpperLeftCornerCell, LowerRightCornerCell) Create a PDF File and save a copy in a Google Drive directory by printing the selected range on letter size paper(8.5 x 11 - to fit on page). And using a FileName provided by the user. Example: myPrintFucntion(Cell_UpperRightCornerOfRange, Cell_LowerLeftCornerOfRange, FileName){ }