Hello

I have a problem with pasting values in a single cell only.

Say I have :

Metro
Home
Centre
451-3434

as a copied value, and I'd like to directly have this pasted in a
single cell including its line spacing.

The macro recording function uses
ActiveSheet.Paste
but it paste values to many cells in a column.

manipulating ActiveCell.FormulaR1C1 ="pasted values here"

seems to be the answer.

What's the script to be able to click on one cell and just activate a
macro that would put in pasted values in a single cell? Thanks


--
Ambrosia
------------------------------------------------------------------------
Ambrosia's Profile: http://www.excelforum.com/member.php...o&userid=28146
View this thread: http://www.excelforum.com/showthread...hreadid=486692