Runtime error 1004 using arrays

[sonyrajan]

Am a little new with VBA programming, and have made a short program to given a simpler interface to using the autofilter function in a worksheet. The program works fine in Excel 2007, however in Excel 2003 the program gives the runtime error 1004 with regard to range.autofilter. The code is as below

The error while debugging is relating to the array that I have defined.

Please Login or Register  to view this content.

Hope the info is sufficient.

The following line gives the error
ActiveSheet.Range("$A$1:$G$996").AutoFilter Field:=1, Criteria1:=ShipArray, Operator:=xlFilterValues
with regard to Criteria1

Thanks in advance

[shg]

Welcome to the forum.

What line errors?

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

[shg]

Sorry for the delay in responding. When all you do is edit your post, I can't tell from looking at my subscribed threads that you have responded.

In Excel 2003, you can't use an array to autofilter. You can specify two distinct criteria, joined by And or Or.