You decared Ooc as Long, so it can contain only Long Ints.

Your other variables are declared as Variant since you didn't include a
type with them (unlike C, each variable needs a type even if they're all
on one line).


In article ,
hippy wrote:

Dim ThsWk, LstWk, Avg, Trgt, Lb, Ub, Ooc As Long