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