Copy/Paste Range Values To Other Sheet

NoSparks · #4 09-20-2024, 06:20 PM

Sorry Logit I don't really know what to do for the emailing
but I do know that if you load the dictionary item with the email address
by change this
uniqueTerms.Add cell.Value, cell.Value
to
uniqueTerms.Add cell.Value, cell.offset(,1).Value

this will show the sheet and who to email

Code:

        'Code from here up to next line of asterisks
         '*******************************************************************
        ' info for email
            MsgBox "the sheet to email is " & wsDest.Name & vbLf & _
                   "the email goes to " & uniqueTerms(wsDest.Name)
           
    Next term

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code to copy data from two sheet ,paste into corresponding sheet through cmdbutton	jackfruit88	Excel Programming	1	07-08-2022 09:27 PM
Copy Excel Range and Paste in PowerPoint Shapes	leops	PowerPoint	4	08-31-2017 06:47 AM
How to copy excel sheet withe HEADER and Paste into new sheet?	cloudforgiven	Excel Programming	6	01-05-2017 07:30 PM
VBA macro to copy range and paste in next blank row	tune2grow	Excel Programming	0	09-03-2014 08:25 PM
Word - Calculate and paste values from Excel sheet	Augf87	Word	1	07-06-2009 10:26 AM