View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dan E[_2_] Dan E[_2_] is offline
external usenet poster
 
Posts: 102
Default Changing the sign of cell using a macro

Jason,

Here's one that'll change the signs of all selected cells

Sub ChangeSign()
For Each c In Selection
c.Value = -c.Value
Next
End Sub

Dan E

"Jason Knauff" wrote in message ...
Does anyone have a macro written that will change the sign
(from positive to negative or negative to positive) of a
number in a cell in excel? Or, does MSFT already have a
keyboard shortcut for this operation? Please help.