Still finding the necessity for the lengthiest code from prince.
It can be achieved in few clicks through excel built in option called
"Remove Duplicates".
Assuming OP is using excel 2007 or later versions as he is working with 6
lakh records.
The below code is enough, even if we want to write in
You're great dude.
On Fri, Jan 4, 2013 at 5:31 PM, Prince wrote:
> most welcome dear.
>
> regards
> prince
>
>
> On Friday, January 4, 2013 5:08:01 PM UTC+5:30, amar takale wrote:
>
>>
>> Thank Very much...Prince
>>
>>
>> On Fri, Jan 4, 2013 at 4:37 PM, Prince wrote:
>>
>>> Public
most welcome dear.
regards
prince
On Friday, January 4, 2013 5:08:01 PM UTC+5:30, amar takale wrote:
>
>
> Thank Very much...Prince
>
> On Fri, Jan 4, 2013 at 4:37 PM, Prince >wrote:
>
>> Public Sub removeDuplicateId()
>>
>> Dim vardata As Variant
>> Dim varRes
Thank Very much...Prince
On Fri, Jan 4, 2013 at 4:37 PM, Prince wrote:
> Public Sub removeDuplicateId()
>
> Dim vardata As Variant
> Dim varRes As Variant
> Dim lngRow As Long
> Dim objDic As Object
>
>
> Set objDic = CreateObject("Scripting.Dic
