Can someone PLEASE help me fix this macro?
Posted by Tim Johnson on December 27, 2001 2:15 PM
Can someone PLEASE help me fix this macro? I need to be able to make multiple numbers negative. I know you can do it by copying a negative 1, and then paste- special-multiply to make it work. I have created the following macro that works for one cell at a time, but I need to be able to do many cells at the same time, and some of them will not be adjacent. Any ideas??
THANK YOU SO MUCH IN ADVANCE!!!!!!!
' NEGATIVE1 Macro
' Macro recorded 12/27/01 by Tim Johnson
ActiveCell.FormulaR1C1 = "-1"
Selection.PasteSpecial Paste:=xlAll, Operation:=xlMultiply, SkipBlanks:= _
Application.CutCopyMode = False