Re: $$Excel-Macros$$ working with array

2012-05-03 Thread ╰» ℓαℓιт мσαнη
* > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* 03 May 2012 18:17 > *To:* excel-mac

RE: $$Excel-Macros$$ working with array

2012-05-03 Thread Rajan_Verma
f & "Column =" & UBound(Arr, 2) End If End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 03 May 2012 18:17 To: excel-macros@googlegroups.com Sub

Re: $$Excel-Macros$$ working with array

2012-05-03 Thread NOORAIN ANSARI
Dear Eduardo, Please try in this way.. Sub Array_Testing() Dim test(50) As String test(0) = Cells(1, 2) test(15) = Cells(1, 3) Cells(1, 10) = test(0) & " " & test(15) End Sub -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 3, 2012 at 6:1

$$Excel-Macros$$ working with array

2012-05-03 Thread Eduardo Cereja
Hi , i need help to work with arrays. I want to create an array and put information ( from cells) in a specific position of that array. For example. Dim test(50) as string test(0)= Cells(1,2) ' cells(1,2)= "LT12" test(15)=cells(1,3) ' cells(1,3) "121" cells(1,10)=test but