elbarauljr
New Member
- Joined
- May 4, 2020
- Messages
- 19
- Office Version
- 365
- 2007
- Platform
- Windows
Hi everyone,
Is there an excel VBA code that allow you to replace part of a formula after cells selection ?
For example, after selecting multiple cells, select the code to replace SUBTOTAL(9, with SUM(
Some formulas examples:
=SUBTOTAL(9,EA10:EA12) change to =SUM(EA10:EA12)
=A4+SUBTOTAL(9,C20:E53) change to =A4+SUM(C20:E53)
=SUBTOTAL(9,EJ410:EJ412)+SUM(EN91:EN92) change to =SUM(EJ410:EJ412)+SUM(EN91:EN92)
Is there an excel VBA code that allow you to replace part of a formula after cells selection ?
For example, after selecting multiple cells, select the code to replace SUBTOTAL(9, with SUM(
Some formulas examples:
=SUBTOTAL(9,EA10:EA12) change to =SUM(EA10:EA12)
=A4+SUBTOTAL(9,C20:E53) change to =A4+SUM(C20:E53)
=SUBTOTAL(9,EJ410:EJ412)+SUM(EN91:EN92) change to =SUM(EJ410:EJ412)+SUM(EN91:EN92)