Avoid using "On error  Resume Next" to trap  non-integers. That looks
like trouble. Instead try something like an If statement and using
the Int() function to determine if it is an integer. Also try using
a breakpoint and stepping through your code  to see what is happening.