<div>
Hi,<br />
<br />
pls try Data / data Tools / Remove Duplicates and select the column you want<br />
<br />
or like this<br />
<br />

<pre><code id="code-20-39796447-1">ActiveSheet.Range(&quot;$A$1:$B$7&quot;).RemoveDuplicates Columns:=1, Header:=xlNo</code></pre>
<br />
<br />
Regards
</div>


Hi,

pls try Data / data Tools / Remove Duplicates and select the column you want

or like this



ActiveSheet.Range("$A$1:$B$7").RemoveDuplicates Columns:=1, Header:=xlNo



Regards

<div>
It's not until I get a reply sometines that I realize I should have been more specific.<br />
<br />
I need to find the duplicates in column A but remove the entire Row.<br />
<br />
Sorry.
</div>


It's not until I get a reply sometines that I realize I should have been more specific.

I need to find the duplicates in column A but remove the entire Row.

Sorry.

<div>
Rgonzo1971 did you see my post to you Re:<br />
<br />
search for text in a file in a folder from an open file
</div>


Rgonzo1971 did you see my post to you Re:

search for text in a file in a folder from an open file

<div>
Hi,<br />
<br />
For the other question, could you open a new question<br />
<br />
Regards
</div>


Hi,

For the other question, could you open a new question

Regards

<div>
<div class="content wysiwyg-content">
I have trolled through EE and various other sites to find a definitive way to remove duplicates with VBA code but they all seem to take forever to complete, reason being that my spreadsheet has over 200000 rows.<br />
<br />
Can any expert provide me with VBA code that will quickly remove duplicates from column A in my spreadsheet.<br />
<br />
Thanks
</div>
</div>


I have trolled through EE and various other sites to find a definitive way to remove duplicates with VBA code but they all seem to take forever to complete, reason being that my spreadsheet has over 200000 rows.

Can any expert provide me with VBA code that will quickly remove duplicates from column A in my spreadsheet.

Thanks

Quick way to remove duplicates with VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.