How can I write a loop to clear cells evenly spaced apart?
Hi guys, I'm getting back into VBA again and I have a task. I need to clear cells that are evenly distance apart. In my eample code, they are 4 columns apart. Basically, I would like a loop to do this for 200 columns or so.
Here is the manual way I am doing it now. Thanks!
[VBA]
Range("A4:A20").Select
Selection.ClearContents
Range("E4:E20").Select
Selection.ClearContents
Range("I4:I20").Select
Selection.ClearContents
Range("M4:M20").Select
Selection.ClearContents
[/VBA]