Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
integer | Excel Worksheet Functions | |||
caused - an integer or decimal number may be required | Excel Discussion (Misc queries) | |||
Create number format for 4 digit integer preceded by zero | Excel Worksheet Functions | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
excel-enter integer number and get two decimal places | Excel Discussion (Misc queries) |