Re: $$Excel-Macros$$ Repeated row to be deleted

2013-04-15 Thread Pravin Gunjal
*Thank Chaya will try with this...* On Mon, Apr 15, 2013 at 11:48 AM, Chaya wrote: > Dear Pravin, > > Replaced - > > ActiveSheet.Range("$A$1:$AL$85").RemoveDuplicates _ > Columns:=3, Header:=xlYes > > by > > ActiveSheet.Range("$A$1:$AL$85").RemoveDuplicates Columns:=Array(2,

Re: $$Excel-Macros$$ Repeated row to be deleted

2013-04-14 Thread Chaya
Dear Pravin, Replaced - ActiveSheet.Range("$A$1:$AL$85").RemoveDuplicates _ Columns:=3, Header:=xlYes by ActiveSheet.Range("$A$1:$AL$85").RemoveDuplicates Columns:=Array(2, 3), _ Header:=xlYes Might help you out. Regards, Chaya On Mon, Apr 15, 2013 at 11:12

Re: $$Excel-Macros$$ Repeated row to be deleted

2013-04-14 Thread Pravin Gunjal
Hi Chaya It must be check in col. B & C and not only C. Pl check and inform. Regards Pravin. On Mon, Apr 15, 2013 at 11:08 AM, Chaya wrote: > Dear Pravin, > > Check the below if it will work out. and you can change the row > number as you like. e.g. AL85 to AL5000 as per your data. > > >

Re: $$Excel-Macros$$ Repeated row to be deleted

2013-04-14 Thread Chaya
Dear Pravin, Check the below if it will work out. and you can change the row number as you like. e.g. AL85 to AL5000 as per your data. Sub Remove_Duplicate() ' Removing Duplicate in c column. Application.ScreenUpdating = False Sheets("FNDWRR").Select Sheets("FNDWRR").Copy After: