A way of retrieving the number of elements in a VBA Array

[m6wiq]

Hi Guys,

I have a small project of developing some VBA Code to simplify a spreadsheet for specifiing IO for Control Systems. In my VBA Code, I have utilised an Array in order to work with the specified spreadsheet range as CountIF will not do what I want it to do (Long Story).

Anyway, I would like to know how I would be able to get a count of the number of entries in my array. Not a count of the values stored in them.

Many thanks,

William

 

[MrTeeny]

Lbound(array) and Ubound(array) will give you the starting and ending indexes,

 

[pgc01]

I have utilised an Array in order to work with the specified spreadsheet range

Hi William
Welcome to the board

Notice that if you read a range into an array you may have 2 indices. In that case use the second parameter of LBound() and UBound() to get the limits.