Email Single Worksheet - No Formulas, Values Only

I've worked out some code that emails the active worksheet as an attachment using Outlook.

I'm scracthing my head trying to figure out where to add additional code (perhaps paste special of sorts) that will remove all formuals from the worksheet attachment and display values instead. Otherwise, when the user receives and opens the attachment he will be notifiied that there are links to other sources outside this workbook (asking to update values/links, etc).

Obviously, I do not want the code to replace my formulas in my actual workbook -- but just for the attachment.

Thanks!

Please Login or Register  to view this content.