The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba training london - Bytes and Integers?

Resolved · Low Priority · Version Standard

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

Bytes and Integers?

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

For upcoming training course dates see: Pricing & availability

ReplyMon 2 Jul 2007, 10:22 Edited on Mon 2 Jul 2007, 10:23Trainer 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

VBA articles

· Make Office work for you with VBA
· Microsoft Excel, Tailor-Made For Your Business Thanks To VBA
· VBA With Excel - Making The Working Day That Little Bit Easier
· VBA For Beginners - Only A Script Away From Endless Possibilities...
· Should You Send Managers To VBA Training?

Vba tip:

Use GoTo to Select A Cell With VBA

To select a certain cell on a Worksheet you can use:

Application.Goto Reference:=Range("V300")

or more simply

Range("V300").Select

If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:

Application.Goto Reference:=Range("V300"), Scroll=True

View all VBA hints and tips

Hello,

I am working on a document that was not created by myself, i have a deadline of Monday and i need to change a few things...

I am struggling to remember what to do to stop the top of a document from displaying on every page when printed?

Al..

» Forum post: Excel

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions