Code working in Excel 2010 but not office 365

Hi Guys & Girls

I have an issue with a code that seems to work in Excel 2010 but not in Office 365. Is there something im missing in the code that differs in the 2 softwares?


The Sheet1 is definetly the active tab where the pivot table is And the column that needs to filter is F.
Could it be that there are blank cells before line 619 and its confusing itself as has no data to filter. If so can someone add anything to this code to ignore the blanks?

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Are you sure this is a pivot table? Because normally you would not use Autofilter to filter a pivot table. That would not explain why it works in one version but not the other, but there may be another way to get the same result that will work in both.

Feel free to attach your file for better diagnosis; see yellow banner at the top of the page.