Pasting help

[Ambrosia]

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

[Don Guillett]

how about

range("destinationcell").value=range("sourcell")
or
range("destinationrange").value=range("sourrange").value
or

--
Don Guillett
SalesAid Software
[email protected]
"Ambrosia" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ambrosia]

Um.... I'm afraid I dont know how to use your answer to my question. Can you explain to me?

[Don Guillett]

try it by replacing with your ranges

--
Don Guillett
SalesAid Software
[email protected]
"Ambrosia" <[email protected]> wrote in
message news:[email protected]...
>
> Um.... I'm afraid I dont know how to use your answer to my question. Can
> you explain to me?
>
>
> --
> Ambrosia
> ------------------------------------------------------------------------
> Ambrosia's Profile:
> http://www.excelforum.com/member.php...o&userid=28146
> View this thread: http://www.excelforum.com/showthread...hreadid=486692
>

[Tim Williams]

Are you copying the pasted value from another cell in Excel, or is it
coming from another application?

Tim

"Ambrosia" <[email protected]>
wrote in message
news:[email protected]...
>
> Um.... I'm afraid I dont know how to use your answer to my question.
> Can
> you explain to me?
>
>
> --
> Ambrosia
> ------------------------------------------------------------------------
> Ambrosia's Profile:
> http://www.excelforum.com/member.php...o&userid=28146
> View this thread:
> http://www.excelforum.com/showthread...hreadid=486692
>

[Ambrosia]

Say it came from another application....

Thanks a lot for the help, but can you tell me how the script should be as a macro?

Say I have a copied values already and all i need to do is activate that macro to paste the values in one cell. Thanks..!

[Rowan Drummond]

You could try something like:

Dim clipb As New DataObject
clipb.GetFromClipboard
ActiveCell.Value = clipb.GetText

You will need to set a reference to the Microsoft Forms 2.0 Object
library to be able to use this. In the VBE select Tools>References and
check the box next to Microsoft Forms 2.0 Object Library.

Hope this helps
Rowan

Ambrosia wrote:
> Say it came from another application....
>
> Thanks a lot for the help, but can you tell me how the script should be
> as a macro?
>
> Say I have a copied values already and all i need to do is activate
> that macro to paste the values in one cell. Thanks..!
>
>