| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move thur range of cells with enter key in excel | Excel Discussion (Misc queries) | |||
| VBA Code to Automatically move text into above cells? | Excel Discussion (Misc queries) | |||
| Spell Check range and move to active cells | Excel Programming | |||
| Select range of cells and move | Excel Programming | |||
| How do I reference the same cell as I move through range of cells. | Excel Worksheet Functions | |||
Threaded Mode
