I have used the Macro Recorder to help copy/paste data from a group of cells to a new page. The group of cells are copied separately and increment all the way across the page. (The code will explain this easier).
Is there an easy way to implement a loop to repeat this same program going down the page? i.e. the next group of cells I would want to copy would be
C14:F19 , I14:L19, etc. all the way to the row starting with C356:F361
The code has been shortened to fit into the post, but should give the general idea.
I know it is crude...but I have developed a macro to just copy/paste the data. However the code is very long and I could use some help with a Loop. I created a new thread concerning this:http://www.excelforum.com/showthread.php?t=622259
Thanks for any help.
Bookmarks