starsky
07-16-2009, 08:54 AM
Hi,
I'm getting a compile error - 'Next without For' for the following code. I don't understand why.
Sub test()
For Counter = 7 To 1000
Set curCell = Worksheets("Sheet1").Cells(Counter, 4)
If curCell.Value = "Yes" Then
curCell.Offset(0, 1).Value = "n/a"
Next Counter
End Sub
Any ideas?
Thanks.
I'm getting a compile error - 'Next without For' for the following code. I don't understand why.
Sub test()
For Counter = 7 To 1000
Set curCell = Worksheets("Sheet1").Cells(Counter, 4)
If curCell.Value = "Yes" Then
curCell.Offset(0, 1).Value = "n/a"
Next Counter
End Sub
Any ideas?
Thanks.