+ Reply to Thread
Results 1 to 5 of 5

Code working in Excel 2010 but not office 365

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    270

    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.
    Last edited by ukphoenix; 06-24-2020 at 02:01 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,540

    Re: Issue with code

    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.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    270

    Re: Issue with code

    Any help on this would be appreciated...

    Is the code workable in a pivot table or is there something different I need to use to create the filter?

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    6,507

    Arrow Re: Code working in Excel 2010 but not office 365


    Hi,

    without any explicit answer according to post #2 : operate manually

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,540

    Re: Code working in Excel 2010 but not office 365

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-07-2016, 12:25 PM
  2. VBA Code Issue
    By billybea in forum Excel General
    Replies: 6
    Last Post: 09-22-2015, 06:13 AM
  3. [SOLVED] Password code designed for 5 Users - NAVIGATION Help Needed! - CODE Issue!
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-09-2014, 10:46 AM
  4. Looking for Worksheet_Change code to fix this issue
    By isritter in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2014, 12:26 PM
  5. Calculation VB Code Issue
    By hedge in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-21-2009, 05:40 PM
  6. Replies: 0
    Last Post: 10-06-2006, 09:05 AM
  7. Intermittent code issue
    By wilro85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2006, 02:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1