Originally Posted By: 1984
Witto, can you explain this row:
$RC = $objExcel.Selection.AutoFilter(4, $Manager)
What does the figure "4" doing?

You should use the Macro recorder and edit the code you recorded.
If you would do so, you would notice after adding an autofilter, starting the recorder and recording the selection of "ManA" in column D, the recorder recorded this code for you:
 Code:
    Selection.AutoFilter Field:=4, Criteria1:="ManA"

4 points to the fourth column in your autofilter