emailing a worksheet

[[email protected]]

Hi

does anyone out there know how email the current worksheet you are working on with several pages?
I do not want to send the whole workbook just 3 or pages of a worksheet.
I have tried to save as a pdf but it only saves the first page

thank you

[darkyam]

You can select the tabs you want to send --> right click --> move or copy... --> select (new book) in the dropdown menu --> check the Create a copy box. Then just send the new workbook.