Subject of the email shall be taken from cell p6 in the sheet. Move to the last cell on a worksheet, to the lowest used row of the rightmost used column ,  · To make it even more user friendly: would like to add an 'email report' button which attaches the active sheet as pdf to a new email. Step– Exploration. Watch as Acrobat online services convert your Excel sheet to PDF automatically. If the cells are blank, move to the last cell in the row or column. Step– Cleanup. 6,  ·Embed VBA to Print Al