Paste Clipboard

P

Pete

How do you paste the contents of your clipboard in the
mouse by Code. I have a spreadsheet in which I have to
copy info from a different workbook and then paste and
reformat the cells and colums in my workbook. I want to be
able to open the workbook and run the macro without having
to first unload my copied info. Is this possible?

Pete
 
K

kram99

Try this Code First copy the cells like this

Worksheets("Your worksheet name").Range("A7:G7").Copy

open workbook to paste into like this

Workbooks.Open ("Your workbook.xls")

Past into sheet like this

ActiveSheet.Paste Destination:=Worksheets("Destination sheet
name").Range("A7:G7")

this code copies the contents of cells A7 to G7 from one workbook to
cells A7 to G7 in another

Hope this help you:D
 
Top