Re: $$Excel-Macros$$ VBA : How to create array dynamically

2014-12-02 Thread Vaibhav Joshi
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* >> -----------

Re: $$Excel-Macros$$ VBA : How to create array dynamically

2014-12-02 Thread Paul Schreiner
” - 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

Re: $$Excel-Macros$$ VBA : How to create array dynamically

2014-12-02 Thread Mahesh Patil
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

Re: $$Excel-Macros$$ VBA : How to create array dynamically

2014-12-01 Thread Paul Schreiner
- 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

$$Excel-Macros$$ VBA : How to create array dynamically

2014-12-01 Thread Mahesh Patil
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