You can multiply two constats using the bang declaration sufix that indicates that they are long values:
? 4692!*283!
1327836
Or
? 4692!*283! 'Error, duplicated
? 4692*283!
1327836
You can multiply two constats using the bang declaration sufix that indicates that they are long values:
? 4692!*283!
1327836
Or
? 4692!*283! 'Error, duplicated
? 4692*283!
1327836
I do not see the difference?![]()
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I just wanted to point out that using the bang declaration sufix does not produce overflow error. The two expressions are equivalent.
Ahhh, I just noticed. The second instruction should only have the bang operator on one of the numbers. Fixed! Sorry
Yes, one can get by with just one of the values being Long.
However for consistency, I would probably make all Long. For my sanity at least, as in a few months, I will have forgotten this.
Does not appear to work for variables though?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
No, you can't add the bang sufix to variables in the inmediate window, but you can use:
A=4692!: B=365! : ? A*B
1712580