vba courses london - Overflow error for long integer

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Overflow error for long integer

Femi has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA course

by - delegate Femi [2 posts] (2007 May 3 Thu, 16:36) Reply

The MS VB help file has an example of an overflow error, i.e.

dim x as long
x = 2000 * 365

Why does this produce an overflow error when x would be 730,000, which seems to be within the range of
-2,147,483,648 and 2,147,483,647?

RE: Overflow error for long integer

by - trainer Carlos gold contributer [413 posts] (2007 May 23 Wed, 13:50) Reply

Hi Femi

I have looked at this and even searched the net and I think there is an error on the example.

The dim should have read:

Dim X as Integer

All the examples I found used Integer, and the Help file example works perfectly using it.

Carlos

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips