Thread: Excel 2007 vs Excel 2003 = Runtime Error 438
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Excel 2007 vs Excel 2003 = Runtime Error 438
The Version Information in this help file shows that it was added in
XL2007...

http://office.microsoft.com/client/h... EV&lcid=1033

--
Rick (MVP - Excel)


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




Reply With QuoteReply With Quote