Array index name

[David Henderson]

thecells.Row will give me the current row
But, is there a name for the index in the array?
I would be most gratefull if someone could enlighten me
Thanks in advance
David

no_values = True
Dim thecells As Range
For Each thecells In Range("quantity_range")
If thecells.Value <> 0 Then
no_values = False
End If
Next

[Nigel]

Each element in the array can be accessed by direct reference to its index
value(s), use the LBound and UBound function to determine the size of an
array.e.g.

MyValue = MyArray(4)




--
Cheers
Nigel



"David Henderson" <[email protected]> wrote in message
news:[email protected]...
> thecells.Row will give me the current row
> But, is there a name for the index in the array?
> I would be most gratefull if someone could enlighten me
> Thanks in advance
> David
>
> no_values = True
> Dim thecells As Range
> For Each thecells In Range("quantity_range")
> If thecells.Value <> 0 Then
> no_values = False
> End If
> Next
>
>