How to create a plus minus switch to convert positive numbers to negative and negative numbers to positive numbers automatically without converting dates and numbers obtained via formulas using VBA.
Here’s the complete VBA code:
Sub PlusMinusConverter()
Dim cel As Range
On Error Resume Next
For Each cel In Selection
If Not cel.HasFormula Then cel.Value = -cel.Value
Next cel
End Sub