Identifiyng an integer number from a floating one
 

Hi there

Please some help here...

Is there any function in vba that identifies an integer number?
I got a program that divides a static variable in a list of many others.
I want to take an action with those numbers that are exact multipliers.

How can i get to know those integer numbers.

Thanx in advance

Jepane

Identifiyng an integer number from a floating one
 

something like:

If ActiveCell.Value = Int(ActiveCell.Value) Then
MsgBox "you have an integer"
Else
MsgBox "you don't have an integer"
End If

Regards

Trevor


"Jepane" wrote in message
...
Hi there

Please some help here...

Is there any function in vba that identifies an integer number?
I got a program that divides a static variable in a list of many others.
I want to take an action with those numbers that are exact multipliers.

How can i get to know those integer numbers.

Thanx in advance

Jepane