+ Reply to Thread
Results 1 to 3 of 3

Selecting Column Data in Pivot Table (from Data model)

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    7

    Selecting Column Data in Pivot Table (from Data model)

    Hi All,
    I recorded the below macro, but I cannot get it running. I did nothing to the original recorded code. I tried looking through the forums cannot cannot find a solution around it.

    Please help to see what went wrong with this code?

    - The pivot table is created with Data model
    - I wanted to select "Vendor A" in column field so that I can draw a border around it.


    Sub Macro12()
    ActiveSheet.PivotTables("PivotTable1").PivotSelect _
    "'[Range].[Release Location].[Release Location]'['[Range].[Release Location].&[LLL]']" _
    , xlDataAndLabel, True
    End Sub
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    06-18-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Selecting Column Data in Pivot Table (from Data model)

    Anyone? Probably by post is not clear?

  3. #3
    Registered User
    Join Date
    06-18-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Selecting Column Data in Pivot Table (from Data model)

    bump, please help~~

+ 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. Cannot Group pivot made from Data Model
    By michellepace in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 07-15-2018, 04:17 PM
  2. power pivot table - Data model
    By pccamara in forum Excel General
    Replies: 2
    Last Post: 04-18-2016, 11:20 AM
  3. Multiple Pivot Tables with Data model - Source Problem
    By siva1612 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2016, 12:27 AM
  4. adding a calculated field to power pivot data model
    By stephme55 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-26-2016, 07:13 PM
  5. [SOLVED] Grouping disabled when pivot table is added to the data model?
    By Rvsalka in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-17-2015, 04:56 AM
  6. Macro for selecting a single item while filtering the data in Pivot Table
    By Syed964 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 01:28 PM
  7. Replies: 2
    Last Post: 03-07-2013, 02:16 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