I am new to arrays and keep having the same issue with any array I declare. For instance, the below code returns the error "compile error: Expected: end of statement". What am I doing wrong? I tried restarting my computer, and starting a brand new module, but to no avail.
Sub somesub()
Dim numbers = New Integer() {1, 2, 4, 8}
End Sub
You can't declare arrays like that in VBA.
There are various options for declaring/populating arrays, this is perhaps the simplest.
Dim numbers As Variant numbers = Array(1,2,4,8)
If posting code please use code tags, see here.
Declarations don't work that way in VBA.
dim numbers(1 to 4) as integer numbers(1)=1 numbers(2)=2 ...
Entia non sunt multiplicanda sine necessitate
Thanks. Is there a way to declare a two (and three) dimensional array using only one line of syntax?
It was done with
Can it be done withDim numbers As Variant numbers = Array(1,2,4,8)
Dim numbers2(1, 1) As Variant
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks