Consulting

Results 1 to 2 of 2

Thread: Calling other macros

  1. #1

    Calling other macros

    The macro I want to do is call one of the six macros that we all do the same but with different data. The main macro is used to call one of the six. I do not know how to do this by recording a new macro to call one of the six. That means I have to create 6 new macros and may also adhere to already have six. The reason I wanted a macro to call one of the six is that the macro could be changes if needed instead of having to make the same change to six individual macros.
    Last edited by Aussiebear; 01-20-2011 at 03:50 AM. Reason: Created a new thread

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,366
    Location
    Quote Originally Posted by kvnfrnk
    The macro I want to do is call one of the six macros that we all do the same but with different data. The main macro is used to call one of the six. I do not know how to do this by recording a new macro to call one of the six. That means I have to create 6 new macros and may also adhere to already have six. The reason I wanted a macro to call one of the six is that the macro could be changes if needed instead of having to make the same change to six individual macros.
    This sounds like we might need to pass arguments or ??? Could you make an example workbook and show us what we're trying to do?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •