+ Reply to Thread
Results 1 to 2 of 2

VBA working in Excel 2013 but not 2010

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    AUS
    MS-Off Ver
    2013
    Posts
    1

    VBA working in Excel 2013 but not 2010

    Hi,
    I have a pivot table field that automatically updated according to a cell value. I use a bit of average VBA coding to update this on a couple of sheets. It works great for me on Excel 2013 however the line below errors on Excel 2010.

    ActiveSheet.PivotTables("PivotTable2").PivotFields("Asset name").PivotFilters.
    Add2 Type:=xlCaptionEquals, Value1:=Range("C4").Value

    Any reason why this would be happening? Thanks all!

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA working in Excel 2013 but not 2010

    In Excel 2010 (and earlier) PivotFilters don't have the Add2 method - they use Add
    Remember what the dormouse said
    Feed your head

+ 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. Macro code working fine in excel 2013 but not in excel 2010.
    By sere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2014, 02:23 AM
  2. Spreadsheet macros working in Excel 2010 but not in Excel 2013
    By boatbabe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2014, 12:03 PM
  3. VBA Working in Excel 2010 and not 2013
    By Jason*** in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2014, 11:28 AM
  4. [SOLVED] Excel 2010 to Excel 2013 Eroor? PivotTable, ListBox VBA not working.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2014, 07:49 AM
  5. 2010 macro not working in 2013 via button
    By PaulieNZ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2013, 01:27 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