Your question is not very clear to me. First off, C2:I2 is made up of 7
cells, but you say you want to copy them into B2:B10 which is made up of 9
cells. Exactly what are you trying to do here? Also, it might help if you
spelled out in more detail what "subsequent ranges" in SHEET 1 that you want
to copy into SHEET 2.

--
Rick (MVP - Excel)


"¦ce" wrote in message
...
I want to copy range C2:I2 in SHEET 1 and paste these in SHEET 2 in range
B2:B10. I also want to repeat this macro by copying and pasting subsequent
ranges in SHEET 1 into SHEET 2.

Someone please help as I've got a cell range of 500 to copy and paste into
SHEET 2. I'm using Excel 2007.

Thanks