Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page VBA: Delete duplicates in each row VBA: Delete duplicates in each row
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 08-29-2015, 11:49 AM
bandaanders bandaanders is offline VBA: Delete duplicates in each row Windows 7 64bit VBA: Delete duplicates in each row Office 2010 32bit
Novice
VBA: Delete duplicates in each row 		 
Join Date: Aug 2015
Posts: 1
bandaanders is on a distinguished road
Default VBA: Delete duplicates in each row
Hi,

could someone please help me?
I need a macro that - after a selection of a range (as usual via leftclicking and dragging the mouse) - removes all duplicates within each row.
An example-files is attached.

TIA!
Attached Files
File Type: xlsx Example delete duplicates in row.xlsx (11.7 KB, 12 views)
Reply With Quote
  #2  
Old 09-02-2015, 07:16 AM
NoSparks NoSparks is offline VBA: Delete duplicates in each row Windows 7 64bit VBA: Delete duplicates in each row Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
Perhaps something along the lines of this...
Attached Files
File Type: xlsm Example delete duplicates in row.xlsm (21.6 KB, 23 views)
Reply With Quote
  #3  
Old 09-02-2015, 08:15 AM
roderh roderh is offline VBA: Delete duplicates in each row Windows 7 64bit VBA: Delete duplicates in each row Office 2010 32bit
Novice
  
Join Date: May 2014
Posts: 17
roderh is on a distinguished road
Default
Hi

Thank you! Almost, what I am looking for!

It seems, it works!

Have a nice day!
Reply With Quote
Reply

Tags
duplicates, vba

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA: Delete duplicates in each row Removing duplicates saurabhlotankar Excel Programming 14 05-26-2015 10:13 AM
Extract duplicates in table goran.c Excel 0 01-21-2015 12:47 AM
VBA: Delete duplicates in each row find and delete duplicates rcVBA Word VBA 4 05-15-2013 03:08 PM
Mail duplicates mixy Outlook 0 02-10-2011 12:54 AM
VBA: Delete duplicates in each row sum of duplicates zxmax Excel 1 09-29-2006 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft