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

2013-04-15 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-15 Thread Pravin Gunjal
*Thank Chaya will try with this...* On Mon, Apr 15, 2013 at 11:48 AM, Chaya chayamon...@gmail.com wrote: Dear Pravin, Replaced - ActiveSheet.Range($A$1:$AL$85).RemoveDuplicates _ Columns:=3, Header:=xlYes by ActiveSheet.Range($A$1:$AL$85).RemoveDuplicates

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

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 chayamon...@gmail.com 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

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

2013-04-12 Thread Pravin Gunjal
Dear Friends I would like to delete the repeated row from the attached sheet. E.g. Row No. 3, 5, 7 and so on up to row no.5000 Can someone help me to this by macro. Thank you, Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s