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 sheet,
stacking them horizontally.

I can get the macro to copy and paste the first block of data, then
switch to next sheet, but i cant get the new sheet, 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 sheet of data.

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

Thanks,

-Adam



*** Sent via Developersdex http://www.developersdex.com ***

See "Copy a range with one area after the last column" at
http://www.rondebruin.nl/copy1.htm

Lots of other very productive information there also.

Cliff Edwards

This really isn't enough help for all you're trying to do, but try something
like this:

ActiveCell.Offset(,4).Select

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ADam Bress" wrote in message
...
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 sheet,
stacking them horizontally.

I can get the macro to copy and paste the first block of data, then
switch to next sheet, but i cant get the new sheet, 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 sheet of data.

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

Thanks,

-Adam



*** Sent via Developersdex http://www.developersdex.com ***