variables
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Variables

Variables

resolvedResolved · Low Priority · Version Standard

replyReply Thu 7 Feb 2008, 16:38Delegate Wendy said...

Wendy has attended:
Excel VBA Intro Intermediate course

Variables

What is the difference between a variant and a variable

For upcoming training course dates see: Pricing & availability

replyReply Sat 9 Feb 2008, 11:27Trainer Stephen said...

RE: Variables

Hi Wendy

Thankyou for your question

A variable is anything that you define at the start of a module or procedure, the value of which will vary throughout the execution of your code.

Variables can be of a range of different types which specify the type of data they can hold. String variables can hold text and numbers, while Byte can only hold numbers in the range 0-255.

Variant is a type of variable. It is a catch all and can hold numeric as well as text and date data.

Hope this is useful

Regards

Stephen

 

Please browse our web site to find out more about
excel courses and other Microsoft training courses.

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard