VBA

Resolved · Low Priority · Version 2003

Thu 17 Apr 2008, 16:33 Delegate 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:44 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips