Positive

[oleg_v]

Hi
i need a help with a macro to make all the numbers in the range A1:H100

positive numbers

thanks

[Bob Phillips]

What numbers will they be? Random, structured?

[JKwan]

how about using the ABS() function?

[Kenneth Hobs]

Sub test()
Dim x As String
x = "A1:H100"
Range(x).Value = Evaluate("if(isnumber(" & x & "),abs(" & x & ")," & x & ")")
End Sub