+ Reply to Thread
Results 1 to 3 of 3

Create a general pivot VBA

  1. #1
    Registered User
    Join Date
    07-29-2015
    Location
    MY
    MS-Off Ver
    office 2010
    Posts
    15

    Question Create a general pivot VBA

    Anyone here please help me, I try to create a general VBA in order to create a pivot table.
    Currently my code can only run on specific type of data, but i want to change it to a general type pivot VBA which can be used even if data type is change.

    Below is my code but with error Argument not optional. Can anyone help me on this? Thanks in advance




    Please Login or Register  to view this content.
    Last edited by limjj; 07-30-2015 at 03:37 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Create a general pivot VBA

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Registered User
    Join Date
    07-29-2015
    Location
    MY
    MS-Off Ver
    office 2010
    Posts
    15

    Re: Create a general pivot VBA

    Done the edit....so can anyone help me?

+ 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: 5
    Last Post: 05-27-2014, 10:09 AM
  2. How to create General Ledger in Excel with or without VBA
    By SVongdara in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 10:03 AM
  3. VB for general pivot table automatically
    By turbo600hp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2012, 01:14 PM
  4. Create general ledger from journal
    By zeshkanii in forum Excel General
    Replies: 0
    Last Post: 07-12-2012, 07:38 AM
  5. General question on Pivot Tables
    By imaquila in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 01-23-2012, 06:40 AM
  6. Pivot Chart General Question
    By Schwizer in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-27-2007, 02:33 AM
  7. pivot tables:general forum
    By tkaplan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-26-2005, 11:21 AM

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