+ Reply to Thread
Results 1 to 4 of 4

Help condensing macro that calls 8 macros.

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Help condensing macro that calls 8 macros.

    I have a large macro that calls about 8 macros. I have it that way because I had to create it one step at a time and I am not good enough to do it in one go. It is ugly, but it works. My only issue really is that now my PERSONAL.XLSB has 8 macros listed in it that really belong to one. So by doing it this way my PERSONAL.XLSB has doubled its list length and makes it harder to find the correct macro.

    Most of the macros are just creating separate pivot tables, but due to the number of items that are excluded, the macro is long. Due to the length, I will have to do more than one post with the code i guess. I will also attached the macro.

    Basically, all I am looking for is to make this one large macro, or at least appear under PERSONAL.XLSB as one, but I doubt simply removing the SUB/END SUB would accomplish that lol


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by taylorsm; 03-08-2017 at 11:51 AM.

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Help condensing macro that calls 8 macros.

    Please Login or Register  to view this content.
    Last edited by taylorsm; 03-08-2017 at 11:52 AM.

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Help condensing macro that calls 8 macros.

    Please Login or Register  to view this content.
    Last edited by taylorsm; 03-08-2017 at 11:52 AM.

  4. #4
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Help condensing macro that calls 8 macros.

    Please Login or Register  to view this content.

+ 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. [SOLVED] Creating a Macro that calls another Macro Dynamically
    By Remotruker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2015, 02:34 PM
  2. Select All Checkboxes Checkbox That Also Calls Checkbox Macros
    By Intervigilium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2015, 06:41 PM
  3. Macro that calls other macros in different sheets (Mudraker)
    By mlcfexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2007, 08:56 PM
  4. Macro that calls other macros in different sheets
    By mlcfexcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-05-2007, 07:44 AM
  5. My menu calls an old macro
    By Claus Højlund in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2006, 12:05 PM
  6. Condensing a macro
    By EstherJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2006, 10:35 AM
  7. Replies: 3
    Last Post: 03-20-2006, 01:25 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