I have the following expression in cell A1 which is input
Input:
30+(A/B)+-(C+D)+-E+-F
And I want it to be evaluated as below and displayed in cells in Column B from B1 through B10:
Output:
30 + A + C + D
30 + A + C
30 + A + D
30 + B + C + D
30 + B + C
30 + B + D
30 + A + E
30 + B + E
30 + A + F
30 + B + F
The input expression is variable and can have several such expressions. How do I approach the VBA macro code?