I consistently get an overflow error at the "SOxBenefit s =" (source code below), while coding in a macros from within Excel, Microsoft XP. I've tried the following:

1. setting a variable equal to a number * CLong(#)
2. changing the variable type, as well as making sure all subsequent variables are of the same type. When attempting to use the ULong type, Excel gives me a mismatch error. I found a thread on how to link...