Longing to be an integer.

Here’s an interesting fact from Microsoft –

VBA converts all integer values to type Long, even if they’re declared as type Integer. So there’s no longer a performance advantage to using Integer variables; in fact, Long variables may be slightly faster because VBA does not have to convert them.

It’s taken from here –


With thanks to this answer for pointing it out –


Although the size of my code has increased, I still don’t think it’s very big, so any speed increase may be minimal. However, as I now know about this, and having spent time previously reviewing all declarations and changing to the smallest (least bits), I feel the need to go through the code and replace any integer declarations to long. Bring on the errors.