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?
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
