Excel 2007 vs Excel 2003 = Runtime Error 438

[Coleman1]

I have created a macro in Excel 2007 with no issues, but when I take it to
work and try to run it using Excel 2003, I keep getting "runtime error 438".

When I debug it takes me to the Line:

Sheets("SHEET1").Select
ActiveSheet.Range("$A$2:$D$3000").RemoveDuplicates Columns:=Array(1, 2,
3, 4), _
Header:=xlYes

Is this not supported in Excel 2003?

 

[Rick Rothstein]

RemoveDuplicates was apparently added in XL2007.

 

[Rick Rothstein]

The Version Information in this help file shows that it was added in
XL2007...

http://office.microsoft.com/client/helppreview.aspx?AssetID=HV100680211033&ns=EXCEL.DEV&lcid=1033

 

[Coleman1]

Thanks Rick. Is there another way to achieve this same action in Excel 2003?

 

[Rick Rothstein]

You will have to write a subroutine to process the cells in the range. There
are plenty of code examples out there that you can use as a template. I'd
start with a Google search using this search string...

excel vba remove duplicates entries