January 7, 2009 6:16 AM Subscribe
Using Excel VBA, how to convert positive numbers to negative, and vice versa?
posted by yezimary to Computers & Internet (16 answers total)
What I want is:
1. Select a range of data;
2. Click the button which is assigned to the Macro;
3. Positive figures in the selected range will turn to negative and vice versa.
OK. I know maybe it is a simple question, but I urgently need this functions while I'm still a newbie to VBA. Anyone can help to write the code? Thanks a lot.