if you used ReDim properly,
>> since it makes the assumption that each first-level element of the
>> array (i = 0 to 2)
>> could have a diffenent secondary element
>> (which it cannot)
>>
>> hope this helps
>> *Paul*
>> -----------
” - John Wesley
-
>
> From: Mahesh Patil
>To: excel-macros@googlegroups.com
>Sent: Tuesday, December 2, 2014 6:11 AM
>Subject: Re: $$Excel-Macros$$ VBA : How to create array dynamically
>
>
>
>Hi Paul,
>Thans for reply.
>I am looking to create variable a
ry element
> (which it cannot)
>
> hope this helps
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To al
-
From: Mahesh Patil
>To: excel-macros@googlegroups.com
>Sent: Monday, December 1, 2014 5:54 AM
>Subject: $$Excel-Macros$$ VBA : How to create array dynamically
>
>
>
>Hello experts,
>'Below code is not working.
>'I need to create array of each
Hello experts,
'Below code is not working.
'I need to create array of each 'element in arname()
' pls suggest solution
' arname () can have more than 100 'elements.
Sub test()
Dim arname() as string
arname(0) = "country"
arname(1) = "state"
arname(2) ="city"
For i= 0 T0 2
arname(i) (50) as strin