Macro to change sign and then move value
I need to change a positive value to become negative value in Excel 2007 and then move the value two cells to the left. This I need to do selectively and repeatedly in a spreadsheet. I create a macro to do this but it does not work as it should.
|