Try something like

Dim V As Variant
V = whatever
If IsNumeric(V) Then
If CInt(V) = CDbl(V) Then
Debug.Print "is integer"
Else
Debug.Print "not an integer"
End If
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ripan " wrote in message
...
Fair enough. IsNumeric makes the distinction between numeric
and not,
but what if I only want integers, and not floats?


---
Message posted from http://www.ExcelForum.com/