vba training london - Bytes and Integers?

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

Resolved · Low Priority · Version Standard

Bytes and Integers?

Philip has attended:
Excel Advanced course
Excel VBA course

by - delegate Philip [1 post] (2007 Jun 21 Thu, 09:53) Reply

What is the difference between a byte type and an integer type?

RE: Bytes and Integers?

by - trainer Carlos gold contributer [360 posts] (2007 Jul 2 Mon, 10:22) Edited on 2007 Jul 2 Mon, 10:23 Reply

Hi Philip

Both of these types are Numeric and ONLY accept Whole numbers.

However the difference is in the SIZE of the memory area:

Byte - As the name suggests it's size is 1 Byte. It can only accept numbers between 0 and 255.

Integer - It's size is 2 Bytes. It can only accept numbers between -32,768 and 32,767.

Regards

Carlos

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

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips