Hi Nihal, While declaring array () is a must, we can ignore the lower and upper bound in declaration statement but not the brackets as the brackets tells compiler to use the variable as array and leaving few spaces in the RAM which will be reconfigurable using redim statement.
Declaring an array actually reserves memory for the entire array. VBA doesn't care whether you fill it up or not, so be conservative when defining array elements. Once you're done with a dynamic array, you can use a ReDim statement to reclaim the memory your array consumed. ------------------------------ Excel VBA Interview Questions<http://www.excelitems.com/2010/12/excel-vba-interview-questions.html> Collection of Excel VBA Macros<http://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html> VLOOKUP<http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html> OFFSET<http://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html#more> ARRAY formulas<http://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html> ------------------------------ Excel 2003 Style Menu in Excel 2007<http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> Custom Number Format<http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html> SUMIFS<http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html> CONTACT a TRAINER<http://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavsto.html> <http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> ------------------------------ Thanks & Regards ------------------------------ Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com Facebook <http://www.facebook.com/eXceLiTems> Twitter<http://www.twitter.com/eXceLiTems> LinkedIn <http://in.linkedin.com/in/ashishjain08> LiveJournal<http://livejournal.excelitems.com/> Digg <http://digg.com/excelitems> Delicious<http://www.delicious.com/save?new=1&url=http%3A%2F%2Fwww.excelitems.com%2F&title=MS%20Excel%20VBA%20%26%20VSTO%20Macros%2C%20Functions%2C%20Tutorials%20%26%20Downloads&type=BOOKMARK&jump=http://www.delicious.com%2Fmountint&key=Nyn3Hc9oMaEzmGO_Fg_jkAwe1hI-©user=mountint&via=mountint©tags=eXceLitems+Office+Microsoft+Functions+Formulas+VBA+VSTO+Excel2010+Excel2007+excel2003+Excel+Bookmarks_Menu+eXceLiTems.com> Subscribe by Email<http://feedburner.google.com/fb/a/mailverify?uri=excelitems> ------------------------------ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
