twelvety
03-14-2009, 06:47 AM
Hi,
I have a question very similar to the one I asked in the thread http://www.vbaexpress.com/forum/showthread.php?t=25626. I need to shift the cells in my spreadsheet to the right by the following amounts.
First block of 19:
row 1 moves 1 to the right
row 2 moves 2 to the right
etc etc moving one more each time until row 9/10 then moving one less
row 17 moves 2 to the right
row 18 moves 1 to the right
Next block of 18:
row 1 moves 1 to the right
row 2 moves 2 to the right
etc etc moving one more each time until row 9 then moving one less
row 16 moves 2 to the right
row 17 moves 1 to the right
Next block of 17:
row 1 moves 1 to the right
row 2 moves 2 to the right
etc etc moving one more each time until row 8/9 then moving one less
row 15 moves 2 to the right
row 16 moves 1 to the right
Is anyone able to offer some code to do this?
Thank you
I have a question very similar to the one I asked in the thread http://www.vbaexpress.com/forum/showthread.php?t=25626. I need to shift the cells in my spreadsheet to the right by the following amounts.
First block of 19:
row 1 moves 1 to the right
row 2 moves 2 to the right
etc etc moving one more each time until row 9/10 then moving one less
row 17 moves 2 to the right
row 18 moves 1 to the right
Next block of 18:
row 1 moves 1 to the right
row 2 moves 2 to the right
etc etc moving one more each time until row 9 then moving one less
row 16 moves 2 to the right
row 17 moves 1 to the right
Next block of 17:
row 1 moves 1 to the right
row 2 moves 2 to the right
etc etc moving one more each time until row 8/9 then moving one less
row 15 moves 2 to the right
row 16 moves 1 to the right
Is anyone able to offer some code to do this?
Thank you