Execute code on a range of cells, then move down and do again?
I have the following code to clear a range of cells. Now I need it to move
down 15 rows and do it again, what do I need to add in to the code?
Range ( _"B9:B21,F9:F21,A20:C21,C19"_ ).Select
Range ("C19") . Activate
Selection.ClearContents
IF Range ("B9" + 15) = 0 THEN
'do again for the cells starting from B9+15
ELSE
End IF
End Sub
TIA
|