Re: Macros and VB in excel

On Feb 20, 1:01 pm, Adam <A...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
So i need to run a little quick and easy macro in excel to help me with this
data i need to compile.  Its somewhat hard to explain, but basically i need
to figure out how to tell the macro to literally just hit the arrow right
key, 4 times, instead of having it recognize specific cells.

I have 30 workbooks with 30 sheets per workbook.   Each sheet has the same
4x10 rows/columns filled out with their own unique data. I need to copy and
paste these 4x10 blocks of data and paste them on a new ***, stacking them
horizontally.

I can get the macro to copy and paste the first block of data, then switch
to next ***, but i cant get the new ***, where i just pasted the data, to
move over 4 columns to the right, to get ready for the next run of the macro
to past the 2nd *** of data.

Does this make sense?  If so, please offer any help you can.

Thanks,

-Adam

I'm not sure exactly how your macros lay out is, but assuming you want
to toggle over 4 columns from the active cell, you can add this code
to the end of your code before it goes to the next ***.

ActiveCell.Offset(0, 4).Select
.