hello
tryif the values are in a range you will be able to loop through them all![]()
Sub changetopostive() ActiveCell.Value = IIf(ActiveCell.Value < 0, ActiveCell.Value * -1, ActiveCell.Value) End Sub
if you have trouble let me know what the range is
hope it help
Bookmarks