Hi all,

I am using Visual Basic 2008 to manipulate some data in a spreadsheet. I am having a problem using Excel's built in RemoveDuplicates function. Here is the line of code I need to fix...

wSheet.Range(strRange).RemoveDuplicates(Columns:=Array(1, 2, 3, 4, 5, 6), Header:=Excel.XlYesNoGuess.xlNo)

The keyword "Array" is where the issue lies. What is "Array" a member of? I tried the object library but did not find it in there. I can use another method to remove the duplicates but am still curious.

Thanks!