Explanation on Arrays

Hey!

I have been using VBA for some time now and i am trying to understand what Arrays are and how and when are they used.

Ive looked up a lot of data on the Internet and watched videos on Youtube.

However I am not very clear on the concept how and when can Arrays be used practically?

Can Gurus shed some light on the same, or atleast direct me to Videos or Study material that would clarify me more??

I will really appreciate that!!

Thank You,

Deep

msexcelathome,

See, especially replies beginning #11:
Re: Curious about why one macro runs so much quicker than another
http://www.excelforum.com/excel-prog...n-another.html


Arrays
http://www.mrexcel.com/forum/showthread.php?t=390246
http://www.cpearson.com/excel/VBAArrays.htm
http://www.xtremevbtalk.com/showthread.php?t=296012
http://www.vbtutor.net/vba/vba_chp21.htm

Array Dimensions in Visual Basic - Working with Dimensions (code and graphics)
http://msdn.microsoft.com/en-us/libr...(v=VS.80).aspx

Thnx a ton.. I look at it..

Cheers!!

Deep

msexcelathome,

Your are very welcome. Glad I could help.