Okay kids, this will probably be simple
Posted by Duane Kennerson on November 26, 2001 5:09 PM
I need a loop that will cut the contents from range b4 and paste it into b1, then cut the contents from b9,and paste it into b6, then cut b14 and paste to b11 etc...... for about 1500 rows. You may have noticed that all of the cells increment by 5 (the cut or paste cells increment by 5 ex. the difference between the paste cells b1, b6 and b11 is 5 if you know what I mean.) but I can't figure out how to make the loop. I can only get it to increment by 1. Please heeeeeeeeeeeeeeelp!