Proper code
I'm surprised noone suggested using the absolute value function, Abs.
If it is possible (Jim did not specifiy how the cell values are set
initially) set the cell value to Abs("cell value"). This way, there would be
no need to go back again and convert them to their positive counterparts.
If VBA code is required to convert them, then the Abs function is an
alternative to multiplying by -1.
Boog
"JimMay" wrote:
I need (In VBA code) to convert a varying range of values,
Say Range("E6:E" & Lrow) from:
-123
-234
-345
-456
To:
123
234
345
456
But can't quite get it going here;
Can someone show me how?
TIA,
Jim
|