centerdialog
New Member
- Joined
- Sep 26, 2018
- Messages
- 25
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.
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.
