Copying Multiple Cells to Clipboard

[rameesareno]

Hi,

Just one quick help needed here.

Scenario is: I want to copy multiple cells into clipboard

Ex:

Name:________
Email:________
Phone:________
Message:_________


----------------
So lets say that Name is in cell A1 and A2 is output and so forth; whats the macro code to add to gather all these cells and put it into clipboard for pasting so output will be like:

Name: Adam
Email: rameeadamsareno@aol.com
Phone: 245-8758877

----------
So it will be possible to paste to a notepad or another excel cell.

Thanks. Please help me, this is for a school project, it will mean a lot!
Thanks. you can contact me directly at rameeadamsareno@aol.com

[teshiburu1988]

try this

im assumin You have Name in A1 and the result in A2 and then B1 and B2 for email and so forth

me.range("A1","D2").select
me.selection.copy

this will copy the ranges you want to the clipboard enabling you to paste them any where you want,

Teshi

[rameesareno]

try this

im assumin You have Name in A1 and the result in A2 and then B1 and B2 for email and so forth

me.range("A1","D2").select
me.selection.copy

this will copy the ranges you want to the clipboard enabling you to paste them any where you want,

Teshi

Thanks.

I wanted the clipboard to copy the label aswell as the result, lets say A1 has Name and B1 is the result of the name and once sent to clipboard = result is

Name: Ramee

and so forth..so when I send this info to the clipboard, its like a form with label and results.

Thanks.