ABS Excel Function

[Pedro]

Hi
ABS excel function is not available in Visual Basic.
What code should I write in order to give me the absolute number

Regards
PEdro

 

[Bob Phillips]

Pedro,

Use the Abs VB function

myVar=Abs(-50.3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[shades]

ABS is a VBA function (see Walkenbach, -Excel 2002 PowerProgramming-,
page 871)

Just to test it, try this: put a number in cell F6, then use this code
to put absolute value into F7. (Shorter way to do this, but gives you
the idea).


Code:
--------------------

Sub Test()
Dim i As Integer
i = Range("F6").Value
Range("F7").Value = Abs(i)
End Sub

--------------------

 

[KJTFS]

if you dont want to use the function then

dim x as double
dim abs as double

if x < 0 then
abs = x * -1
else
abs = x
endif

Keith
www.kjtfs.com

ABS is a VBA function (see Walkenbach, -Excel 200
PowerProgramming-, page 871)

Just to test it, try this: put a number in cell F6, then use thi
code to put absolute value into F7. (Shorter way to do this, bu
gives you the idea).
Code
-------------------

Sub Test()
Dim i As Integer
i = Range("F6").Value
Range("F7").Value = Abs(i)
End Sub
-------------------
[/B