vba courses london - How do you do an array?

Resolved · Low Priority · Version Standard

Thu 10 May 2007, 16:30 Delegate Toby said...

Toby has attended:
Excel VBA Intro Intermediate course

How do you do an array?

Fri 1 Jun 2007, 10:12 Trainer David said...

RE: How do you do an array?

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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

VBA tip:

Use GoTo to Select A Cell With VBA

To select a certain cell on a Worksheet you can use:

Application.Goto Reference:=Range("V300")

or more simply

Range("V300").Select

If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:

Application.Goto Reference:=Range("V300"), Scroll=True

View all VBA hints and tips