Get the Number of Items in an Array Variable in VBA and Macros in Excel

Go to http://www.teachmsoffice.com for this and hundreds of other tutorials and training in Excel and Microsoft office.

This Excel VBA macro tutorial shows you how to determine the number of items or elements contained within an array variable. This is very important when you want to loop through an array variable. Note, this is not necessarily the same as the upper bound or last index number of an array variable and it can take some extra work, which is covered in this tutorial, to determine exactly how many elements are contained within an array variable.



This tutorial published with permission from http://www.teachmsoffice.com

Category:

Education

Tags:

• excel
• macro
• vba
• visual
• basic
• retrieve
• find
• number
• elements
• items
• index
• array
• variable

[ExcelisHell]

@ducksaj There are a few different ways to achieve what you might be wanting, but I have tutorials on all of that now on teachmsoffice. com

[ducksaj]

Hello, I think if you dont know nobody does, so, is there a way to create a macro to set up the macro security level to "down" automatically, because threre are many users dont know how to do it, thank you very much....