Paste Clipboard

  • Thread starter Thread starter Pete
  • Start date Start date
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
 
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
 
Back
Top