Thread: Counting Loops
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan G.[_2_] Dan G.[_2_] is offline
external usenet poster
 
Posts: 7
Default Counting Loops


Hello.

I'd like to count how many times particular parts of a loop peform. (At
least I think that's what I want.)

So I have:

Do Until ActiveCell.Value = ""

If ActiveCell.Value < 0 Then
ActiveCell.Cut ActiveCell.Offset(0, 56)
ActiveCell.Offset(0, 1).Activate
Else
ActiveCell.Offset(0, 1).Activate
End If

Loop

and I'd like to know how many times the first instructions are
performed, and how many times the second part of the statement is
performed.

Hope that makes sense. Thanks.

Dan



*** Sent via Developersdex http://www.developersdex.com ***