I need to convert the following filter statement into Excel 2003 format. I do not have Excel 2003 and am not sure the syntax to use for this version.
The Operator (xlFilterValues) is not valid in 2003 as this relates to the new checkbox style filter in the newer versions.
TX
Code: Select all
With Range("A4", rCell(lRow))
.AutoFilter Field:=rCell.Column, Criteria1:=Array("E(P)", "L(P)", "S(P)"), Operator:=xlFilterValues