View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
babs babs is offline
external usenet poster
 
Posts: 38
Default 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