Please any help.

I am trying to Remove duplicates from an excel Spreadsheet I generate. I've looked up the method via MSDN and tried to translate it to KIX. I've also Googled and found nothing specific to my issue.

Per MSFT the default VB basic method is as follows:

ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes

Column and Header are both Optional, I omitted column for debugging and also since I wish to use all columns, but as I have a header I've used it in my code as follows:

$xlHeader = 1

$rc=$oxl.Range("A1:C$EXCELROW8").RemoveDuplicates(,$xlHeader)

others combo's I've tried:
$rc=$oxl.Range("A1:C$EXCELROW8").RemoveDuplicates(,,$xlHeader)
$rc=$oxl.Range("A1:C$EXCELROW8").RemoveDuplicates(,,$xlHeader,)
$rc=$oxl.Range("A1:C$EXCELROW8").RemoveDuplicates(,,,$xlHeader)
$rc=$oxl.Range("A1:C$EXCELROW8").RemoveDuplicates(,,,$xlHeader,)

My variable - $EXCELROW8 is simply the end of my data set.

I've tried several permutations all for naught. I can only assume I've got the structure totally wrong or it requires a bit more then I'm guessing at. I have found many examples of sorting, formatting and other code port overs, which I've tweaked and used successfully, but nothing relating to this and it has me stumped.

I receive no errors unless I make a deliberate typo but the code does not work. So I'm missing something and grabbing at straws.

Any help or suggestions would be greatly welcomed.

Cheers and Thanks