Delete Duplicate Rows Runtime Error Invalid Procedure Call or Argument

[NorthbyNorthwest]

Hi, hope someone can help me. I have a very large data set which includes duplicate rows. I need to delete these rows. Normally, I delete based on a column. However, in this case I want to delete the row based on every column containing duplicate information. I tried code below and got runtime error 5, invalid procedure call or argument. Is my data set too large? Or is there something wrong with procedure? How can achieve my goal? Thanks.

[SIZE=3][COLOR=#000000][FONT=Calibri]Sub RemoveDupRows()<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]   Sheets("output").Range("$A$1:$A$662592").RemoveDuplicatesColumns:=Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15), Header:=xlNo<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]End Sub

<o></o>[/FONT][/COLOR][/SIZE]

 

[JoeMo]

Hi, hope someone can help me. I have a very large data set which includes duplicate rows. I need to delete these rows. Normally, I delete based on a column. However, in this case I want to delete the row based on every column containing duplicate information. I tried code below and got runtime error 5, invalid procedure call or argument. Is my data set too large? Or is there something wrong with procedure? How can achieve my goal? Thanks.

[SIZE=3][COLOR=#000000][FONT=Calibri]Sub RemoveDupRows()<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]   Sheets("output").Range("$A$1:$A$662592").[/FONT][/COLOR][COLOR=#ff0000][FONT=Calibri][B]RemoveDuplicatesColumns[/B][/FONT][/COLOR][COLOR=#000000][FONT=Calibri]:=Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15), Header:=xlNo<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]End Sub[/FONT][/COLOR][/SIZE]

<o></o>

Assuming the part I highlighted in red is a typo in your post, your range does not cover 15 columns. Should that range be:
Range("$A$1:$O$662592") ??????

 

[NorthbyNorthwest]

Thanks, for the second pair of eyes. Sometimes we (me in this instance) overlook the obvious! Again, many thanks.

 

[JoeMo]

Thanks, for the second pair of eyes. Sometimes we (me in this instance) overlook the obvious! Again, many thanks.

You are welcome - thanks for the reply.