Identifiyng an integer number from a floating one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identifying Weekends 1
Trying to add Long Integer field 1
Check if a number is an integer. 2
Integer convert to minutes. 5
return the current row number for use in a formula 2
Your entry cannot be used. An integer or decimal number may be req 3
Need a formula for a descimal integer into a whole number 1
Help creating a formula that repeats text & increments an integer 3

Back
Top