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
*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
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
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
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