Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

variables

ResolvedVersion Standard

Wendy has attended:
Excel VBA Intro Intermediate course

Variables

What is the difference between a variant and a variable

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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.