vba courses london - How do you do an array?

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

How do you do an array?

Toby has attended:
Excel VBA course

by - delegate Toby [1 post] (2007 May 10 Thu, 16:30) Reply

How do you do an array?

RE: How do you do an array?

by - trainer David gold contributer [428 posts] (2007 Jun 1 Fri, 10:12) Reply

Hi Toby

To create an array in VBA, you need a statement such as:

Dim myArray(1 To 8) As Integer

This will create an array of Integers using the values provided in this case 1 to 8.

an alternate is
Dim myArray As Variant
myArray = Array(1, 2, 3, 84 5)

There are many other types of array, i.e. an array of strings that you should look into.

Hope this helps

David

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Empty The Clipboard with CutCopyMode

After each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload:

ActiveSheet.Paste
Application.CutCopyMode = False

View all VBA hints and tips