replace minus values for values contain bracket

[KalilMe]

I got this code for @Rick Rothstein it's very efficiant . now I want if i run repeatedly then return the values to become minus and when the values is minus and run the macro then should contain bracket and so on every time run the macro should change from minus to bracket and bracket to minus

Sub MakePlusMinusAndMinusPlus()
  With Range("A2:H" & Columns("A:H").Find("*", , xlValues, , xlRows, xlPrevious).Row)
    .NumberFormat = "General;(General)"
  End With
End Sub

 

[steve the fish]

This is a simple toggle that will work if all values are formatted the same. If you have combinations it wont.

With Range("A2:H" & Columns("A:H").Find("*", , xlValues, , xlRows, xlPrevious).Row)
    If .NumberFormat = "General;(General)" Then
        .NumberFormat = "General"
    Else
        .NumberFormat = "General;(General)"
    End If
End With

 

[KalilMe]

thanks very much