Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 vs Excel 2003 = Runtime Error 438
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 vs Excel 2003 = Runtime Error 438
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 vs Excel 2003 = Runtime Error 438
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 vs Excel 2003 = Runtime Error 438
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code Works Fine in Excel 2007, Excel 2000 generates Runtime Error 438 | Excel Programming | |||
Excel 2003 Runtime Error | Setting up and Configuration of Excel | |||
Excel 2000 - Excel 2003 now throws 'runtime error' | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Excel 2003 Help Runtime Error | Excel Discussion (Misc queries) |