Friday 27 August 2010

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

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


Video:


Description:Go to 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

Published:
28/Aug/2010

No comments:

Post a Comment