Determining an Integer Value

Summary: One of the math functions you can use in your macros is the Int function. It provides a way for you to derive an integer value from whatever original values you are working with. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

VBA, true to its BASIC roots, provides a function to return the integer value of an expression. This means that anything to the right of the decimal point is truncated. Thus, if a formula would normally result in a value such as 18.73, then the integer value of that formula would result in 18.

The syntax for the integer function is as follows:

x = Int(y)

where x is the result and y is a value or an expression that evaluates to a value.

Tip #3437 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Step Up and Take Control! Subscribers to WordTips know just how valuable a resource it is. WordTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on WordTips archives and e-books.

Check out WordTips Premium today!