Thread: How to confirm a cell entry is a whole number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
smartin smartin is offline
external usenet poster
  
Posts: 915
Default How to confirm a cell entry is a whole number
Robert Flanagan wrote:
Any suggestions on how to confirm that the value in a cell is a whole
number?

Bob



Def IsWholeNumber as Boolean
IsWholeNumber = MyValue = Abs(Int(MyValue))
Reply With QuoteReply With Quote