Array index name

  • Thread starter Thread starter David Henderson
  • Start date Start date
D

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

For next index 1
Macro to iterate through rows in a worksheet (problem) 3
Vlookup with mouse over definitions 2
Process of records 1
Error with calling Format sub 7
Array to Multiple Arrays 3
Loop is slow trying array code 17
Check for Required Fields, an hilarious error! 11

Back
Top