123rickfear
Active Member
- Joined
- Jun 19, 2015
- Messages
- 446
Below is the part of my code I am having trouble with.
Instead of just copying E2, I would like it to copy E2 and F2 and put a ; in between (the data in E2 and F2 are email addresses).
Range("E2").Select
Selection.Copy
Windows("Booking Test Working Copy Macro Test.xlsm").Activate
Range("B16").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Any help would be greatly appreciated.
Thanks
Instead of just copying E2, I would like it to copy E2 and F2 and put a ; in between (the data in E2 and F2 are email addresses).
Range("E2").Select
Selection.Copy
Windows("Booking Test Working Copy Macro Test.xlsm").Activate
Range("B16").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Any help would be greatly appreciated.
Thanks