Odd or even?

Does anyone know how to check in VBA whether an integer is odd or even?
In Excel the methods IsOdd and IsEven are available, but they don't seem to be around in VBA. Not even with the worksheetfunctions object.

Bit of a novice programmer but one way you could do it is using the MOD operator.
This divides 'number1' by 'number2' and gives you the remainder so if you divide your integer by 2 and the remainder is greater than 0 then the integer is odd.

e.g.
[result field] = 10 mod 2
(The [result field] will be 0 therefore 10 is an even number)

This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.

Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.

The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…