Heli,
Is this directed to my thread?

Why even bother ?
If your code performs using the last record and your code is robust enough to cater for the usual user values "I know it said enter a number from 1 to 9 but "Three" is a number from 1 to 9 !" then it either works or your input validation is not up to scratch. If you take the view that your users are "out to get you" then as you said in an other post "use something other than Excel" or give up now !