AutoFilter does not work in 2003

[majosum]

I have a macro that automatically filters a field in a data set by a value the user can select in a drop-down box. It works perfectly in 2007.

Please Login or Register  to view this content.

CityState is a variable that I defined. It is set equal to whatever the user selects from the drop-down list.

However, one coworker is running Excel 2003 on his computer and this line always appears as an error when running the macro. I've tried a few run-arounds to no avail. Does anybody have a solution to this problem?

Thanks!

[AB33]

You are running it on the active sheet. The cursor has to be on the active sheet before you run the code, otherwise the code will pick up any sheet which happens to be active at the time of running the code.

[majosum]

Thanks for the reply AB33.

In my original post, I included just 1 out of hundreds of lines of code. Before that line, I have the macro activate the sheet that contains the data and select a cell so that the cursor is on that worksheet.

Like I said, the macro runs perfectly in 2007, but doesn't work in 2003. I assume it is a compatibility issue.

[AB33]

I do not see any compatibility issue. It is more likely to do with either drop-down box or Criteria1:=CityState.
Did you run the code yourself?

[majosum]

Yes. I ran it on both computers that run the two different versions of Excel.

[AB33]

Oops!

This line

Please Login or Register  to view this content.

will not work as the limit of rows in 2003 was 65k.

[majosum]

That's it! Thank you so much! I fixed that line everywhere but missed that one.