View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rayo K Rayo K is offline
external usenet poster
 
Posts: 28
Default Check if a value is an integer using VBA code

I know I should be able ot do this but I'm drawing a blank and nothing seems
to be working. I want to check a series of user entered values in a vertical
range, see if they are integers, and place them in a 1D integer array. If
they are not postive integers, the array values will be set to zero ( the
range values can remain whatever they are).

How can I do this?