Thread: For next index
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Henderson David Henderson is offline
external usenet poster
 
Posts: 17
Default For next index

The code below has a for next loop in it
how can I find out the "position" , ie is it the first time through the
loop, the last or the "n" th time through the loop.
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