98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Variables
Variables
Resolved · Low Priority · Version 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Finding your worksheets quicklyThe arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook. |