|
|
#2
05-23-2018, 08:51 AM
|
|||
|
|||
Hi
In Ron's code, immediately after sh.copy and before Set wb = ActiveWorkbook insert the following 3 lines of code and that should achieve what you want Code:
ActiveSheet.UsedRange.Copy
ActiveSheet.UsedRange.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
ActiveSheet.UsedRange.PasteSpecial Paste:=xlPasteFormats
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I mail merge just part of one worksheet | tomseeley | Excel | 0 | 01-25-2014 12:10 PM |
 How to forward all e-mails from one address to five (5) other e-mail address?
|
adi2012 | Outlook | 1 | 09-09-2012 06:41 PM |
|
Word mail merge from a protected Excel worksheet
|
Platform | Mail Merge | 10 | 09-28-2011 05:12 AM |
| cannot receive my own e mail and from same address | vb55 | Outlook | 0 | 03-13-2009 11:38 AM |
|
mail receipent with an excel worksheet attachment
|
jburke@holidayinnislip.co | Office | 1 | 11-14-2005 08:55 AM |
Windows 10 
Office 2016
Threaded Mode