Vba arrays declaration.

[Metafisica]

Hello,
I'm new to this forum and i have not presented myself. If that is rude i'sorry.

Im developing an app over vba-excel.

My question is, can i declare 2 or more arrays on the same line, like:

Dim arr(), arr2(), arr3() as integer

Im used to do that with variables but i seem to have problems if i do it with arrays.

I dont seem to have problems with:


Dim vble,vble2, arr3() as integer

I would like some clarification and thanks in advance

Yours metafisica.

[Colin Legg]

Welcome to the forum.

You can, but you need to be aware of the data types.

In VBA, when you declare your variables:

Please Login or Register  to view this content.

This line actually defines a and b as Variants and c as an Integer.

To declare all three as Integer types, you need to do it like this:

Please Login or Register  to view this content.

Similarly, for your line of code here:

Please Login or Register  to view this content.

If you want all three to be Integer arrays, you need to use:

Please Login or Register  to view this content.

If you continue to have problems, please post back with the specifics.

[Metafisica]

Good night (spanish time)
Thank you very much for your fast and accurate reply.

That explains why sometimes i have problems and smtimes not. It can be a problem when vb offers that much flexibility. I was defining variants and on most times it works but it gives space for trouble.

It remebers me the time when i wasnt using "option explicit". It was great fun whenever i misspelled a vble name and it automatically defined a new one.

Again thanks, u just got yourself a free beer (or soda if you fancy) when u come to Madrid.
Yours metafisica.

[Colin Legg]

I'm delighted to hear you're using Option Explicit and next time I am in Madrid I will take you up on the beer!

If you're happy with the answer provided, please mark your thread as solved. Thanks.

[shg]

A craven solitation for Demon Rum, Mr Legg -- for shame!