Excel 2007 vs Excel 2003 = Runtime Error 438

C

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?
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top