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

--
Rick (MVP - Excel)


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

"Rick Rothstein" wrote:

RemoveDuplicates was apparently added in XL2007.

--
Rick (MVP - Excel)


"Coleman1" wrote in message
...
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?