+ Reply to Thread
Results 1 to 5 of 5

Macro: Remove Duplicate before Pasting Text (on selected cells)

Hybrid View

rampal Macro: Remove Duplicate... 01-23-2013, 08:00 AM
mike7952 Re: Macro: Remove Duplicate... 01-23-2013, 09:35 AM
rampal Re: Macro: Remove Duplicate... 01-23-2013, 10:23 AM
mike7952 Re: Macro: Remove Duplicate... 01-23-2013, 10:24 AM
rampal Re: Macro: Remove Duplicate... 01-23-2013, 10:31 AM
  1. #1
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Macro: Remove Duplicate before Pasting Text (on selected cells)

    Why are you using?

        With New MSForms.DataObject
        .SetText str
        .PutInClipboard
    End Sub
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  2. #2
    Registered User
    Join Date
    06-05-2012
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Macro: Remove Duplicate before Pasting Text (on selected cells)

    i prefer the data be putted in the clipboard (instead of in a pop-up msgbox) so it can be pasted into word or notepad
    that's why i changed back to the original

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1