sure...

just use the ranges to define variables for each...

xval = Range("A1")
yval = Range("B1")
zval = Range("C1")
Sheets("Sheet2").activate
Range("A5") = xval
Range("B2") = yval
Range("F10") = zval

Hope this helps

Gareth

Magnivy Wrote:
Greetings!

Is it somehow possible to copy multiple items on one worksheet
separately,
not as a group, and paste each item on another worksheet. For example
say
cells A1:C1 contain x,y,and z. Is it possible to copy the three items
separately, then go to Sheet2 and paste x in cell A5, y in cell B2, an
z in
cell F10 without returning to Sheet1 and recopying each item.

I hope I explained it well. Please let me know if you have difficulty
understanding my question.

Any help on this would be greatly appreciated.

Magniv

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54856