Set print area for a dynamic range and launch print dialog

I have a workbook with multiple worksheets containing a template "Statement of Account"

Records are entered on each row until the last entry for the month.

The columns range is static but I want to define the print area only to the last entry on the last row.

B12 to M last row.

The "Header" is already defined in the rows to repeat page setup.

I would like to set a dynamic print range based on the last row and launch the print dialog to print to CutePDF.

I would like to be able to apply this VBA code to the "active sheet" so the user doesn't have to define which sheet is to be printed.

Any help will be greatly appreciated.

thank you Humdingaling

After the print area has been defined i'd like to launch the print dialog so the user can select CutePDF from the printer selection. then they will save the CutePDF file to the nominated folder.

Is this something you can assist with in VBA code?

That is, automatically select CutePDF as the format after the print area has been defined, then ask the user which folder they wish to save the file to?

Kind regards

Thank you so much! your help is very much appreciated.