VBA

Tagged

Articles that specifically discuss features of the VBA programming language.

Avoiding Overflow Errors When Defining Calculated Constants

Overflow errors are usually straightforward. But what about when you get an overflow assigning a value of 1 to a Long integer?

It's probably irresponsible of me to share the following technique with you because you'll be so tempted to abuse it. But let's do it anyway.