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, and 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.

Magnivy

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

Got it! Thank you very much Gareth!

"pianoman" wrote:


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, and
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.

Magnivy


--
pianoman
------------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=548562