Code that works in one location but not another location. (AdvancedFilter excel function)

I can't post the full code but can explain what I am doing. I'm wondering if anyone else has had this issue before.

In one section of my macro I want to run the following line of code.

Please Login or Register  to view this content.

The code only works for a certain number of items on the second sheet of the workbook. If I run the same code on the same items in the same spot, but on the first worksheet, everything works correctly.

To re-clarify everything...

I have Worksheet 1, Worksheet 2, and Worksheet 3. The advanced filter only works for about 500 items on the second worksheet but for any number of items on worksheet 1. IS there some setting I am missing that is causing me these problems? This issue is actually pretty serious for me and I can't figure out why it's happening.

Please Login or Register  to view this content.

I do not see any error with the syntax, but since you have not qualified the worksheet you want to work, the code may confuse if you jump from one sheet to another while you are working on the workbook. You have to be on the active sheet when you run the code and should stay on it until the code ends.