98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
VBA
Resolved · Low Priority · Version 2003
Thu 17 Apr 2008, 16:33Delegate David said...
David has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
VBA
I still do not understand the need for all the Bytes, Long, integer, String Variable Length String Fixed length Variant String and Variant Numeric. Are these classifications only to save on memory usage. Surely any variable of any length should be standard?
Mon 21 Apr 2008, 09:44Trainer Carlos said...
VBA Variables
Hi David
You are right. Vriables can be declared as
Dim MyVariable
with no data type. Thia will default it to a Variant type (A standard +22 byte size).
However to save memory usage in the running of the code data types were introduced.
Remember that VBA has been around from the time when 64Mb & 128Mb RAM were considered very large and top technology, so programers had to find ways to reduce memory usage.
Hope this helps
Carlos
Training information:
|
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:Importing Numbers in Excel 2010Occasionally, when importing data into Excel you find that the some of the imported values are treated as text. |
