Hello All--
I am trying to create a macro that basically takes a formula (or hardcoded value), wraps it in parenthesis with a negative sign in front, and then removes the negative sign and parenthesis. The process I am thinking of is below:
1. [Formula or Hardcoded Value]
2. Macro activated: (-[Formula or Hardcoded Value])
3. Macro activated again (back to original cell information in step 1): [Formula or Hardcoded Value]
I have tried to figure this out, and am able to get to step #2 above, but cannot figure out how to revert it back to the original value (step #3). Any help would be appreciated.
I am trying to create a macro that basically takes a formula (or hardcoded value), wraps it in parenthesis with a negative sign in front, and then removes the negative sign and parenthesis. The process I am thinking of is below:
1. [Formula or Hardcoded Value]
2. Macro activated: (-[Formula or Hardcoded Value])
3. Macro activated again (back to original cell information in step 1): [Formula or Hardcoded Value]
I have tried to figure this out, and am able to get to step #2 above, but cannot figure out how to revert it back to the original value (step #3). Any help would be appreciated.