|
-
Feb 9th, 2005, 10:40 PM
#1
Thread Starter
Addicted Member
[RESOLVED] Premature loop ending
The following code is not working properly...it works for the first cell but then it quits even though there is value in the adjoining cell
Sub Downtime()
Range("G1").Select
For q = 0 To 500
ActiveCell.Value = ActiveCell.Offset(0, 1).Value - ActiveCell.Offset(0, 2).Value
ActiveCell.Offset(1, 0).Select
If ActiveCell.Offset(0, 1).Value = "" Then
Exit For
End If
Next
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|