QUOTE(Stuuuuuu @ Sep 30 2008, 06:01 AM)

hey all, first post for me,
if i declare a variable intK as integer, and set that variable equal to 5.4*2, what will be in that variable?
actual code would be:
dim intK as integer
intk = 5.4 * 2
hopefully someone out there has some basic skills
Since the variable is of integer type, it will ignore everything after the comma, so the result will be 10 in the above example.
Remember that the Integer type in VBA is limited to values between -32,768 to 32,767.
For calculations outside of this scope, use the Long type, which is 4-byte integer variable type (so the usuable range is 2^32).
Good luck!