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 VBA Training and help » vba courses london - How do you do an array?
vba courses london - How do you do an array?
Resolved · Low Priority · Version Standard
Thu 10 May 2007, 16:30Delegate Toby said...
Toby has attended:
Excel VBA Intro Intermediate course
How do you do an array?
How do you do an array?
Fri 1 Jun 2007, 10:12Trainer 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 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. |
VBA tip:Use GoTo to Select A Cell With VBATo select a certain cell on a Worksheet you can use: |
