+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Using Macros

  1. #1
    Registered User
    Join Date
    12-29-2008
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Pivot Table Using Macros

    I am trying to insert a pivot table using Excel Macros. I thought that I could just record the creation of a pivot table, but when I try to run the macro a "Run-time error '1004'" appears. Does anyone know why? The code I tried to put in that does not work is:

    Please Login or Register  to view this content.
    Any idea why this is not going through?

    Thanks a ton!

    Yoav
    Last edited by rylo; 12-30-2008 at 07:40 PM. Reason: added code tags

  2. #2
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465
    Sir,
    Try this

    Please Login or Register  to view this content.
    Last edited by rylo; 12-30-2008 at 07:41 PM. Reason: added code wraps
    __________________
    Regards
    Rahul Nagar
    Founder of www.myshortcutkeys.com.


    If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
    Also
    If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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