Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba training london - Bytes and Integers?

vba training london - Bytes and Integers?

ResolvedVersion Standard

Thu 21 Jun 2007, 09:53 Delegate Philip said...

Philip has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Bytes and Integers?

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

Mon 2 Jul 2007, 10:22 Edited on Mon 2 Jul 2007, 10:23 Trainer Carlos said...

RE: Bytes and Integers?

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

vba training london - Bytes and Integers?

Bytes and Integers?

RE: Bytes and Integers?

VBA articles

VBA tip:

Count the Rows and Columns in a Selection