Hi,
Very new to VBA so I have written a very basic code so that a worksheet in my workbook will send via an email once I run the macro. This does all work fine however when copying the worksheet I want the format to stay the same and not paste the formulas as the sheet picks up information from a different work sheet in the work book and when sending on email these are copied over too and returning a #NA. Any help on this would be appreciated, below is the code I have written and a quick screen shot of the sheet for what I want to send.
Very new to VBA so I have written a very basic code so that a worksheet in my workbook will send via an email once I run the macro. This does all work fine however when copying the worksheet I want the format to stay the same and not paste the formulas as the sheet picks up information from a different work sheet in the work book and when sending on email these are copied over too and returning a #NA. Any help on this would be appreciated, below is the code I have written and a quick screen shot of the sheet for what I want to send.
