'ABSOLUTE Value VBA & HH Value

[excelcandy]

I need to convert a cell value to the absolute value through VBA (if negative, make it positive)
A formula needs to be converted into its value (like pressing F9 on any formula to makeit the result)

[JieJenn]

if you want to make a numeric value absolute, maybe use abs function. Abs(Range("A3").value))

[excelcandy]

Thanks, and part 2 ?

[JieJenn]

I don't understand your part 2 sorry.

[excelcandy]

when you select the content within a cell and press F9 it deletes the formula and inserts the result

example
before
6*2
after
12

-> no formula left, vanishes

[excelcandy]

Abs(Range("A3").value))

is not working! just goes red - syntax error

[JieJenn]

Can you post your workbook?

[excelcandy]

no, sorry this is not working. Abs(Range("A3").value)) does not work