Results 1 to 2 of 2

Thread: Cycle multiple Excel functions in single macro
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2018
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Cycle multiple Excel functions in single macro

    I am trying to create two macros and would really appreciate some help on this, as not sure where to begin.

    1. AutoSum Min on first execute then AutoSum Max on second execute (if the macro is executed in the same cell). Then beyond the second execute, the macro should cycle through these two functions in that order (or reset the cycle if executed in a different cell).

    I find myself using the AutoSum Min and Max functions frequently and would like to bind them to a single shortcut with the use of a macro. If I press the shortcut once, I'd like the macro to execute AutoSum Min, if I press the shortcut twice then I'd like AutoSum Max, etc.

    2. The same as above, except with AutoSum Average and then AutoSum Median.


    Any help would be appreciated, thanks.

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Cycle multiple Excel functions in single macro

    Hello,

    Why don't you post the two macros you are currently using ...

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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