How to run 2 macros when worksheet is updated
Closed
Veronika
-
Sep 16, 2011 at 04:53 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 16, 2011 at 09:15 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 16, 2011 at 09:15 AM
Related:
- How to run 2 macros when worksheet is updated
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Feeding frenzy 2 download - Download - Arcade
- Resident evil 2 remake free download - Download - Horror
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 16, 2011 at 09:15 AM
Sep 16, 2011 at 09:15 AM
No a macro can have more than one macro.
However your macro needs parameters. I dont see you passing any thing when you call Worksheet_Change.
Other issue is that your both are functions. Function return value. So in the change event had you even passed the parameter to your two functions, it would not matter as the function values are not used.
you can try to add
Application.volatile to both functions. This would result if there is any change in any formula, this function would be recalcuated too.
However your macro needs parameters. I dont see you passing any thing when you call Worksheet_Change.
Other issue is that your both are functions. Function return value. So in the change event had you even passed the parameter to your two functions, it would not matter as the function values are not used.
you can try to add
Application.volatile to both functions. This would result if there is any change in any formula, this function would be recalcuated too.